11.6 Migrating the Database Schema

  1. In the MySQL Metadata Explorer window, select the Filr MySQL database and tables that you want to migrate, then click Convert Schema.

    This creates the database schema on the target Microsoft SQL server. Ensure that the target schema has the database_name with a .dbo extension. If the target schema does not have the database_name or has an extension other than .dbo, then click Modify and select the correct schema.

  2. In the SQL Server Metadata Explorer section, right-click the MySQL database that you are migrating, then click Synchronize with Database.

  3. In the Synchronize with the Database dialog box, verify that the tables will be created, then click OK.

  4. Continue with Migrating Data.