Migrating Older Databases
From InterBase
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.
- 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
-a
switch instead of the-x
switch. This extracts objects created in GDML. - 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 );
- 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");