Migrating Older Databases
Go Up to Migrating Databases to Dialect 3
If you have legacy databases in which some data structures were created with GDML, you may need to extract metadata in a slightly different way.
- 1. Try extracting metadata as described in Step 2 on page Method One: In-place Migration and examine it to see if all tables and other DDL structures are present. If they are not, delete the metadata file and extract using the
-aswitch instead of the
-xswitch. This extracts objects created in GDML.
- 2. You may have to change some of the code to SQL form. For example, the following domain definition
CREATE DOMAIN NO_INIT_FLAG AS SMALLINT ( no_init_flag = 1 or no_init_flag = 0 or no_init_flag missing);
- needs to be translated to:
CREATE DOMAIN NO_INIT_FLAG AS SMALLINT CHECK ( VALUE = 1 OR VALUE = 0 OR VALUE IS NULL );
- 3. Some code may be commented out. For example:
CREATE TABLE BOILER_PLATE (BOILER_PLATE_NAME NAME, DATE DATE, CREATED_DATE COMPUTED BY /* Date */);
- needs to be changed to:
CREATE TABLE BOILER_PLATE (BOILER_PLATE_NAME NAME, "DATE" DATE, CREATED_DATE COMPUTED BY "DATE");