Database Migration

It's easy to move a database from one database engine to another with the Database Migration Wizard.

Database Workbench will automatically recognize supported features in the destination and act accordingly. For example, if your target database doesn't support the NVARCHAR data type, it will use VARCHAR and possibly a corresponding character set. If it doesn't support TINYINT, it will take an integer data type one size larger. Or if it doesn't support multi-directional indices, it will create a single directional index instead.

The wizard will take you through the steps required and you can either create the database objects directly or generate a script. A detailed report with issues found is generated too.

You can migrate a database from any ODBC or ADO data source to quickly start a new development project.

  • Migrate complete database or individual objects
  • Support for cross database system migration
  • Automatically map data types from one system to another
  • Objects are converted, SQL generated and optionally directly created
  • Detailed results for the migration process

Migration Wizard

The Database Migration Wizard lets you choose a source and destination for your migration.

Next it will allow you to select objects suitable for migration. When migrating between different database systems, you won't be able to select all possible object types.

Use the options to fine tune migration or object selection and optionally create the objects directly or just generate a valid SQL script.

Detailed Results

After the migration process has finished, there's a detailed report for info about each object.

If you opted to create the objects directly instead of only generating a script, this report shows you whether creation was succesful.

Quick Migration

It's possible to quickly migrate individual or multiple objects using Quick Migration. Simply use the context menu in the Database Navigator and the Database Migration dialog will be shown.

The same options as per wizard are available, but only objects of the same type are selectable.