B.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.

  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 Section B.7, Migrating Data.