(Show Contents)

Schema Rebuild Routines for Sybase

The rebuild process should be done very carefully because if explicit clean folder paths, with empty destination folders, are not given for the destination files, the Sybase rebuild will not execute successfully.

Note: The lowest version of the database engine that we support must be used for the rebuild. Currently, this is Sybase v7. Do NOT use a newer version, as the resulting database will not be compatible with the oldest database engines that we support.

To rebuild the Sybase schema database:

1. Use Sybase Central's "Create Database" utility to create a new blank Sybase database, selecting the following options:

   Note: In each form, change only the options below to be selected ON - all other options should be left to the default settings that the "Create Database" utility presents.

• Connection created by a local engine.
• Path and filename for the new database: Choose a clean path and file name here, such as: C:\Program Files\Afm14\Projects\SchemaRebuild\newSchem.db.
• No Transaction log.
• [] Ignore trailing blanks in comparisons.
• Collation Sequence: o The following: UTF8.

2. Use Sybase Central's Unload utility to unload the schema.db, using the following settings:

   Note: In the appropriate form, change only the following options to be selected ON - all other options should be left to the default settings that the "Unload" utility presents.

• User: DBA
• Password: SQL
• Database - Start Line: C:\Program Files\Sybase\SQL Anywhere 7\win32\dbeng7.exe
• Database - Database File: {C:\Program Files\Afm14\Schema\Sybase\Schema.db}
• Path and filename for Reload.sql: {choose a clean path here such as: C:\Program Files\Afm14\Projects\SchemaRebuild\reload.sql}

3. Reload into an existing database:

• User: DBA
• Password: SQL
• Database - Start Line: C:\Program Files\Sybase\SQL Anywhere 7\win32\dbeng7.exe
• Database - Database File: {C:\Program Files\Afm14\Projects\SchemaRebuild\newSchem.db}

4. You will be prompted to select whether the directory for the unload data should be created. Choose "Yes".
5. Once the process is completed (it can take about15-30 minutes):
   1. Close all Sybase applications.
   2. Rename NewSchem.db to Schema.db
   3. Open the new Schema.db in ARCHIBUS to insure that the process was successful.
   4. Perform database regression tests on the new Schema.db to insure that everything is functional. Load a few views from each of the applications, and enter and edit data in some editing views.