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 Schemas 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, general log information, or both (see the figure that follows).

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

Figure 10.52 MySQL Workbench migration: Fetch Schemas List

Content is described in the surrounding text.

Schemas Selection

Choose the databases you want to migrate over to MySQL.

The Schema Name Mapping Method step provides the following options for 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 schemas 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 (see the figure that follows).

  • 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.53 MySQL Workbench Migration: Schemas Selection

Content is described in the surrounding text.