6
Disconnected Source Model Loading

The Disconnected Source Model Load feature of the Migration Workbench allows consultants to work on a customer's database migration without having to install and run the Migration Workbench at the customer site.

To perform the disconnected source model load option a customer must generate delimited flat files containing schema metadata from the database to be migrated. You generate the flat file by running a predefined Migration Workbench script against the source database. The flat files are sent to a consultant who uses the Migration Workbench to load the metadata files into a source and Oracle model. You can then map this schema to Oracle.

Generating Database Metadata Flat Files

Informix Dynamic Server databases use the Bulk Copy Program (BCP) to generate delimited metadata flat files. Predefined scripts installed with the Migration Workbench invoke the BCP, and generate the flat files for each database. The BCP outputs delimited metadata files from the database with a .dat extension. However, for a successful migration of a database the .dat metadata files are converted into XML files by the Migration Workbench. The Migration Workbench converts the .dat files when the source metadata files are selected during the capture phase of the migration, and outputs the generated .xml files to the same root directory as the source .dat files.

Flat File Generation Scripts

The predefined script file for Informix Dynamic Server is in the %ORACLE_HOME%\Omwb\DSML_Scripts\informix7 directory.

Running the Script

To run the script file from the %ORACLE_HOME%\DSML_scripts\informix7 directory, use the following command line:

IDS7_DSML_SCRIPT <root dir> <servername>