Partners
MS SQL Data Wizard online Help
Prev  |
Return to chapter overview | Next  |
Data Pump Options
The Options dialog allows you to customize your work with the Data Pump Wizard.
To open this dialog, click the More button at any step of the wizard and select the Options | Data Pump Preferences menu item.
Common
The General group allows you to manage the following options:
Confirm exit from application
This option enables/disables the application exit confirmation dialog.
Retrieve list of available databases from server
Uncheck this option if your Microsoft SQL server does not allow the SHOW DATABASES command. With this option unchecked, databases are not retrieved to the list, but you have to enter the database type manually or select a database from the list of previously used databases.
Options of the Hidden steps group allow you to customize the number of the wizard steps. Check an option to skip the corresponding step, e.g. if you do not need to view or edit the target script before its execution, check the Target database script option, and this step will not appear after the Data Tables step.
Convert names to SQL92 standard
Check this option to convert all source object names to SQL92 standard when generating the target script.
Confirm target object changes
With this option checked, Data Pump Wizard requests a confirmation each time you change any properties of the target database object.
Select all import tables default
With this option checked, all tables are default selected for data import at the appropriate step (or if this step is hidden, all tables are imported on conversion).
Replacements
Use this list to replace some definite source object names with other names when converting them to the target database, e.g. object names, which cannot be converted to SQL92 standard. Click Add to add a replacement item and set the expected source object name as Text to find and the required target object name as Replace with. Check Ignore case to search source objects without case sensitivity. Use the Edit and Delete buttons to edit and delete the replacement items respectively.
Actions
Here you can specify the default behavior of the application when an error occurs:
creating error (possible values are abort, continue)
importing error (possible values are abort, continue)
posting error (possible values are abort, skip importing table, continue)
inserting error (possible values are abort, skip importing table, ignore this field, continue).
However, if you check the Confirm on Error option, the confirmation dialog will appear if an error occurs.
Note: The Confirm on Error option is not applied to the Data Pump tasks which are performed with MS SQL Data Wizard Agent. If a task is running in background mode, then the application will stick to the specified actions by default, and no confirmation dialog will appear.
| Prev |
Return to chapter overview | Next |
