Previous Topic Next topic Print topic


To create an SQL script file of the migration

To create a script file containing the DDL statements used to perform the migration, select the Generate SQL checkbox in the Run dialog box when you execute the migration. In the text-entry field next to the checkbox, type the name of the file to which you want the script written. If this file does not exist, Migrate creates it. If it exists, Migrate overwrites it with the new script.

Note:

The script that Migrate creates contains only the DDL statements that define the destination table. It does not contain individual INSERT statements for each migrated record.

You can use the SQL command on the View menu to display the contents of an SQL script file, including one to which you have saved migration SQL.

When the Select SQL File dialog box is displayed, select the SQL file and click OK.

After the file is displayed, you can print it using the Print command on the File menu.

Previous Topic Next topic Print topic