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.

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 -a switch instead of the -x switch. 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");

Advance To: