9/10

Beta Draft

# 5 Disconnected Source Model Loading

The Disconnected Source Model Load feature of SQL Developer allows consultants to work on a customer's database migration without having to install and run SQL Developer 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 SQL Developer script against the source database. The flat files are sent to a consultant who uses SQL Developer to load the metadata files into a source and Oracle model. You can then map this schema to Oracle.

## 5.1 Generating Database Metadata Flat Files

Microsoft SQL Server databases use the Bulk Copy Program (BCP) to generate delimited metadata flat files. Predefined scripts installed with SQL Developer 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 SQL Developer. SQL Developer 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.

### 5.1.1 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 SQL Developer script:

Table 5-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

#### 5.1.1.1 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>