Using the Schema Migration Wizard
Go Up to Schema Extraction and Migration
DBArtisan offers robust cross-DBMS-platform object migration capabilities that can migrate schema and table data between databases on the same or different servers. DBArtisan's migration capabilities automatically resolve differences between DBMS platforms, alleviating the responsibility of knowing the syntax and object variations inherent in database platforms. The Schema Migration Wizard sequences the creation of objects in the proper order to eliminate dependency errors. It also has the intelligence to use the fastest method available for copying table data.
The Schema Migration Wizard lets you:
- Create a new schema migration operation.
- Re-use a previously defined schema migration operation.
- Specify a source and a target datasource.
- Specify server object types, database object types, and general migration options.
- Select specific objects and to set certain migration options for each object type.
- Specify the dependent object types automatically migrated for any object type.
- Specify object ownership.
- Specify if the migration operation is to be saved for reuse.
- Caution: Schema migration jobs created in earlier versions of DBArtisan that were saved with a .migrate file extension must be re-created in DBArtisan 8.1 or later. Only migration jobs with a .sav extension can be reused.
The table below describes the object types that can be migrated to different supported platforms and the utility used to accomplish the migration operation:
Source | Target | Object Type | Data Out Method | Data In Method |
---|---|---|---|---|
DB2 |
DB2 |
All Object Types & Data |
DB2 Export API Call |
DB2 Import API Call |
SQL Server |
Tables, data, views, indexes, users |
SQL SELECT |
BCP Utility | |
Sybase ASE |
Tables, data, views, indexes, users |
SQL SELECT |
BCP Utility | |
Oracle |
Tables, data, views, indexes, users |
SQL SELECT |
SQL * Loader Utility | |
SQL Server |
SQL Server |
All Object Types & Data |
BCP Utility |
BCP Utility |
Sybase ASE |
All Object Types & Data except functions |
BCP Utility |
BCP Utility | |
Oracle |
Tables, data, views, indexes, logins |
SQL SELECT |
SQL * Utility | |
DB2 |
Tables, data, views, indexes, logins |
SQL SELECT |
DB2 Import API Calls | |
Oracle |
SQL Server |
All Object Types & Data |
BCP Utility |
BCP Utility |
Sybase ASE |
Tables, data, views, indexes, logins |
BCP Utility |
BCP Utility | |
Oracle |
All Object Types and Data |
SQL SELECT |
SQL * Utility | |
DB2 |
Tables, data, views, indexes, logins |
SQL SELECT |
SQL * Utility | |
Sybase ASE |
Sybase ASE |
All Object Types & Data |
BCP Utility |
BCP Utility |
SQL Server |
All Object Types & Data except functions |
BCP Utility |
BCP Utility | |
Oracle |
Tables, data, views, indexes, logins |
SQL SELECT |
SQL * Utility | |
DB2 |
Tables, data, views, indexes, logins |
SQL SELECT |
DB2 Import API Calls |
To copy objects between servers, the Schema Migration Wizard establishes separate connections to both the source and target servers. Based on the copy options you choose, it then migrates schema from the source to the target database. If the bulk copy command is used when copying table data, a temporary BCP file is built in the temp directory of your computer.
- Note: Before migrating, ensure that any object requirements, restrictions, or restrictions are satisfied. For details, see Migration and Object Restrictions/requirements.
To Open the Schema Migration Wizard
- Connect to the datasource from which you want to migrate schema. For details, see Connecting to Datasources.
- On the Datasource Navigator/Explorer, select the target database or database object.
- On the Utilities menu, select Schema Migration.
- The Migration Wizard opens.
- Use the following table as a guide to understanding and setting options in the wizard:
Panel | Tasks and Settings | Description |
---|---|---|
Playback |
Perform new migration and Playback an existing migration |
Lets you start a new migration or select an existing migration script you want to replay from the drop-down list. NOTE: When the wizard opens, you can make changes to the operation you are replaying. |
Connection |
Source Datasource and Target Datasource |
Lets you select the datasource from which you want to migrate the schema and the datasource to which you want to migrate. |
Catalogs (only displayed for multiple database DBMS datasources) |
Source Database and Target Database |
Lets you select a source and target database. |
Object Selection |
Schemas |
Opens a dialog that lets you narrow the choice of candidate objects by selecting only those associated with specified schema. |
Object Types |
Lets you select the object types that will be migrated. You can use the expand/collapse icons to hide and show the dependent object types for each object. As you select object types, all objects of that type (that satisfy the Schemas criteria) are made available for selection in the Objects list. Selected dependent object types are also made available in the Objects list. For information on setting the dependent object type automatically selected to be extracted along with each object type, see DDL Extract Options. | |
Objects |
Lets you select the specific objects that will be extracted. For each object selected, you can also select the specific dependent objects that are to be extracted. | |
Options |
This panel lets you choose migration options and view an Example Preview script that is updated as you choose options. It also lets you save your options choices as an template, with an option to use the saved template as the default. For a detailed descriptions of the options presented on this panel, see Common Schema Migration and Extraction Options. | |
Summary |
This panel presents the following options: | |
Output script to file |
Lets you specify the name and path of a file to store the output script. | |
Save existing operation |
Lets you save a copy the choices you made on the wizard panels. On subsequent schema migrations, you can then playback the saved migration settings, optionally changing option settings. You specify the path and name of the file in which to save the migration operation. | |
Click Finish when ready to proceed with the extraction. | ||
Execute |
Displays the status of the migration with details on the number of objects retrieved and created, the number of errors detected, and the elapsed time. Filter options (Show All, Show Errors, and Show Warnings) let you display specific types of messages generated during the migration process. When the extraction completes, you can also use the following option: | |
Continue |
Opens the extraction script in the ISQL Editor. For more information, see Coding Environments/Editors. | |
Report |
Opens a detailed report on the results of the schema migration. |