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

Microsoft SQL Server and Sybase Adaptive 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 files are stored in the %ORACLE_HOME%\Omwb\DSML_Scripts\<plugin> directory. Refer to the following table to locate the correct Migration Workbench script:

Table 6-1 Location and Name of Script Files and Name of Associated Files

Plug-in	Directory Location	Script File Name	Associated Files
Microsoft SQL Server 6.5	%ORACLE_HOME%\DSML_scripts\sqlserver6	SS6_DSML_SCRIPT.BAT	CREATE_SS65_INDEX_TABLES.SQL DROP_SS65_INDEX_TABLES.SQL
Microsoft SQL Server 7	%ORACLE_HOME%\DSML_scripts\sqlserver7	SS7_DSML_SCRIPT.BAT	Not Applicable
Microsoft SQL Server 2000	%ORACLE_HOME%\DSML_scripts\sqlserver2000	SS2K_DSML_SCRIPT.BAT	Not Applicable
Sybase Adaptive Server 11	%ORACLE_HOME%\DSML_scripts\ybase11	SYBASE11_DSML_SCRIPT.BAT	CREATE_SYBASE_INDEX_TABLES.SQL DROP_SYBASE_INDEX_TABLES.SQL
Sybase Adaptive Server 12	%ORACLE_HOME%\DSML_scripts\sybase12	SYBASE12_DSML_SCRIPT.BAT	CREATE_SYBASE_INDEX_TABLES.SQL DROP_SYBASE_INDEX_TABLES.SQL

Running the Scripts

To run a script file for a plugin from the
%ORACLE_HOME%\DSML_scripts\<plugin> directory, use the following command line:

<script file name> <database> <password> <server>

For example, to run the Microsoft SQL Server 2000 script file to generate metadata flat files, use the following command:

SS2K_DSML_SCRIPT <database> <password> <server>