SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

Migrating MySQL Databases to SQL Server / SQL Azure

SQL Server Migration Assistant (SSMA) for MySQL is a comprehensive environment that helps you quickly migrate MySQL databases to SQL Server or SQL Azure. By using SSMA for MySQL, you can review database objects and data, assess databases for migration, migrate database objects to SQL Server or SQL Azure, and then migrate data to SQL Server or SQL Azure.

To successfully migrate objects and data from MySQL databases to SQL Server or SQL Azure, use the following process:

  1. Working with SSMA Projects (MySQL to SQL).

    After you create the project, you can set project conversion, migration, and type mapping options. For more information about project settings, see Setting Project Options (MySQL to SQL). For information about how to customize data type mappings, see Mapping MySQL and SQL Server Data Types (MySQL to SQL)

  2. Connecting to MySQL (MySQL to SQL)

  3. Connecting to SQL Server(MySQL to SQL)

  4. Mapping MySQL Databases to SQL Server Schemas(MySQLToSQL)

  5. Connecting to SQL Azure

  6. Optionally, Assessing MySQL Databases for Conversion (MySQL to SQL) to assess database objects for conversion and estimate the conversion time.

  7. Converting MySQL Databases (MySQL to SQL)

  8. Synchronization

  9. You can do this in one of the following ways:

    • Save a script and run it on SQL Server or SQL Azure.

    • Synchronize the database objects.

  10. Migrating MySQL Data into SQL Server/ SQL Azure

  11. If necessary, update database applications.

NoteNote


You cannot migrate Information_schema and MySQL schemas.

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.