Related Documentation Download this Manual
PDF (US Ltr) - 15.0Mb
PDF (A4) - 14.9Mb
EPUB - 13.2Mb
HTML Download (TGZ) - 13.1Mb
HTML Download (Zip) - 13.1Mb

10.8.2 Schema Retrieval and Selection

Retrieve a list of available databases and choose the specific databases (and tables) that you want to migrate to MySQL.

Fetch Schemas List

The Schemata list is retrieved from both the source and target RDBMS. The account used for the connection will need to have appropriate privileges for listing and reading the schemas you want to migrate. Target RDBMS connection settings will also be validated. This is an automated and informational step that reports connection related errors and/or general log information.

The steps that are performed include: connects to the source DBMS, checks the connection, and retrieves the schema list from the source.

Figure 10.54 MySQL Workbench migration: Fetch Schemas List

MySQL Workbench migration: Fetch Schemas List

Schemas Selection

Choose the databases you want to migrate over to MySQL.

This Schema Name Mapping Method options while migrating from Microsoft SQL Server:


This example uses Microsoft SQL Server as the source RDMS. Although the options will be different for other database systems, the concept remains the same.

  • Keep schemata as they are: Catalog.Schema.Table -> Schema.Table: This will create multiple databases, one per schema.

  • Only one schema: Catalog.Schema.Table -> Catalog.Table: Merges each schema into a single database.

  • Only one schema, keep current schema names as a prefix: Catalog.Schema.Table -> Catalog.Schema_table: Preserves the schema name as a prefix.

Figure 10.55 MySQL Workbench Migration: Schemas Selection

MySQL Workbench migration: Schemata Selection

User Comments
Sign Up Login You must be logged in to post a comment.