This dialog box appears whenever you choose Action->Generate Migration Scripts. The SQL migrations scripts are generated automatically during the creation phase of the migration process. However, you can also generate these scripts manually through this dialog box by choosing the schema objects that you want to generate migration scripts. When you generate the migration scripts the create.sql and the drop.sql files in the OMWB/migration_scripts directory are overwritten with the new scripts.
Selecting a Schema Object
The schema objects are automatically selected by default. If a schema object that you want to create is in the Available list, you can do one of the following to move it to the Selected list:
Double-clicking the name of the schema object.
Highlighting the name of the schema object, then click the right arrow (>).
Select all of the available schema objects by clicking the right double arrow (>>).
Note: You must select at least one schema object before clicking the OK option.
Deselecting a Schema Object
If you do not want to create a schema object, do one of the following to move it from the Selected list to the Available list:
Double-clicking the name of the schema object.
Highlighting the name of the schema object, then click the right arrow (>).
Deselect all of the schema objects by clicking the right double arrow (>>).
This dialog box contains the following commands:
Cancel
Cancels this dialog box.
Help
Displays online Help about this dialog box.