Skip to content

migrating-mysql-databases-to-sql-server-azure-sql-db-mysqltosql.md

Latest commit

 

History

History
55 lines (37 loc) · 3.2 KB

migrating-mysql-databases-to-sql-server-azure-sql-db-mysqltosql.md

File metadata and controls

55 lines (37 loc) · 3.2 KB
title Migrate MySQL Databases to SQL Server - Azure SQL Database
description Use this recommended process to migrate MySQL databases to SQL Server or Azure SQL Database using SQL Server Migration Assistant (SSMA).
author nilabjaball
ms.author niball
ms.date 01/19/2017
ms.service sql
ms.subservice ssma
ms.topic upgrade-and-migration-article
ms.collection
sql-migration-content
ms.custom
intro-migration

Migrating MySQL Databases to SQL Server - Azure SQL Database (MySQLToSQL)

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.

Recommended Migration Process

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

  1. Working with SSMA Projects (MySQLToSQL).

    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 (MySQLToSQL). For information about how to customize data type mappings, see Mapping MySQL and SQL Server Data Types (MySQLToSQL)

  2. Connecting to MySQL (MySQLToSQL)

  3. Connecting to SQL Server (MySQLToSQL)

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

  5. Connecting to Azure SQL Database (MySQLToSQL)

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

  7. Converting MySQL Databases (MySQLToSQL)

  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 - Azure SQL Database (MySQLToSQL)

  11. If necessary, update database applications.

Note

You cannot migrate Information_schema and MySQL schemas.

See Also

Installing SSMA for MySQL (MySQLToSQL)
Getting Started with SSMA for MySQL (MySQLToSQL)