MySQL Workbench Manual  /  ...  /  Schemata Retrieval and Selection

10.8.2 Schemata 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 Schemata List

Schemata 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: Schemata Selection

MySQL Workbench migration: Schemata Selection

Download this Manual
PDF (US Ltr) - 14.7Mb
PDF (A4) - 14.7Mb
EPUB - 12.8Mb
HTML Download (TGZ) - 12.7Mb
HTML Download (Zip) - 12.8Mb
User Comments
Sign Up Login You must be logged in to post a comment.