B.7 Migrating Data

  1. In the MySQL Metadata Explorer window, select the Filr MySQL database and tables that contain the data that you want to migrate.

    To avoid timeout errors, migrate large tables individually, as described in Step 6.

    The Connect to MySQL dialog box is displayed.

  2. Accept the defaults for connecting to the Microsoft SQL server, then specify the user name and password for a user with sufficient rights on the database.

  3. Click Connect.

    The Connect to SQL Server dialog box is displayed.

  4. Accept the defaults for connecting to the Microsoft SQL Server, then specify the user name and password for a user with sufficient rights on the database.

  5. Click Connect.

    The data is migrated. Depending on the amount of data and number of tables in your database, this process can take a few minutes.

    After the migration finishes, the Data Migration Report is displayed. You can save the report for your records, or close it without saving.

  6. (Optional) To migrate individual tables, repeat Step 1 through Step 5 and select the table that you want to migrate in the MySQL Metadata Explorer window.

  7. Run the following queries in sequence against the migrated database using the SQL Query Editor of the Microsoft SQL Server:

    ALTER DATABASE filr SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
    ALTER DATABASE filr COLLATE Latin1_General_CI_AS_KS_WS;
    ALTER DATABASE filr SET MULTI_USER;
    SELECT name, collation_name FROM sys.databases WHERE name = N'filr';

    If your database name is something other than filr, replace filr with the name of your database.

    These queries must be successfully executed in the correct order before continuing.

  8. Continue with Section B.8, Running Post-Migration Scripts.