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: