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

1. Connect to the datasource from which you want to migrate schema. For details, see Connecting to Datasources.
2. On the Datasource Navigator/Explorer, select the target database or database object.
3. On the Utilities menu, select Schema Migration.

   The Migration Wizard opens.

4. 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.

Topics

• Executing Statements Before or After Creation of Functions or Procedures