Retrieve a list of available databases and choose the specific databases (and tables) that you want to migrate to MySQL.
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.
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.