Object Menu

The Object menu contains items that are enabled when an object is selected in either the Source Model or Oracle Model tree. You can also access these menu items using the right mouse button.

Create

Creates an object in the container you have selected in the Oracle Model. For example, choose the Tablespaces container in the Oracle Model to create a new tablespace. This menu item is disabled if the container you have selected does not support the creation of objects.

Delete

Deletes the object you have selected in either the Source Model or Oracle Model. If you select a container, all items in the container are deleted. However, the Migration Workbench still displays the container, but indicates that it is empty. This menu item is disabled if the object you have selected cannot be deleted.

Note: If you delete a table, any schema object, such as stored procedures, triggers, or views, that is dependent on that table is also deleted.

Rename

Renames the object you have selected in the Oracle Model. This menu item is disabled if the object you have selected cannot be renamed.

Parse

Parses the stored procedure, trigger, or view you have selected in the Source Model. This menu item is disabled if you have not created the Oracle Model.

Migrate Table Data

Migrates the data for the table you have selected in the Oracle Model. This menu item is only enabled once you have used the Migration wizard to create the users and tables in the destination Oracle database.

Generate SQL*Loader Scripts

The Migration Workbench uses MS SQL Server or Sybase BCP in conjunction with SQL*Loader to provide significant performance improvements for data migration in large tables. The following steps outline what happens when you choose Object -> Generate SQL*Loader Scripts. For illustration purposes, these steps refer to MS SQL Server 6.5.

The base directory for the SQL*Loader script output for MS SQL Server 6.5 is <Log Directory>\SQLServer6. <Log Directory> is the location specified in the Logging page of the Options dialog box. The Migration Workbench creates a directory under this base directory that represents the date and time at which the SQL*Loader scripts were generated. For example, a sub-directory called 1-10-1999_17-58-16 indicates that the scripts were generated at 17:58 on 1st October, 1999.

  1. A BCP extraction script called bcp_extract.bat is created in the <Log Directory>\SQLServer6\1-10-1999_17-58-16 directory.

  2. As part of the Generate SQL*Loader Script command, a sub-directory called Oracle is created in the <Log Directory>\SQLServer6\1-10-1999_17-58-16 directory. SQL*Loader control files and a SQL*Loader script called sql_load_script.bat are placed in this Oracle directory. The SQL*Loader control files expect the data files that are created to be located in this directory also. Therefore, you should copy the bcp_extract.bat file into the Oracle directory before you execute it.

  3. Run bcp_extract.bat to generate the data files. This extracts the data from the table(s) into data files called <tablename>.dat.

  4. The destination Oracle database does not necessarily reside on the same computer as the Migration Workbench. In this case, you should FTP the entire <Log Directory>\SQLServer6\1-10-1999_17-58-16\Oracle directory to the computer on which the destination Oracle database resides.

  5. Execute the sql_load_script.bat file to insert the data from the data files into the equivalent Oracle tables.