Edit

Install SSMA for MySQL client (MySQLToSQL)

The SQL Server Migration Assistant (SSMA) client migrates MySQL databases. Supported target versions include SQL Server 2019 (15.x) and later versions on Windows and Linux, Azure SQL Database, and Azure SQL Managed Instance. The client:

  • Connects to the MySQL source and the SQL Server Database Engine target.
  • Converts database objects for the target.
  • Loads the converted objects into the target.
  • Migrates the data.

This article provides the installation prerequisites and instructions for installing SSMA for MySQL client.

Prerequisites

SSMA for MySQL is designed to work with MySQL 4.1 and later versions.

Before you install SSMA, make sure that the computer meets the following requirements:

  • Windows 11 or later versions, or Windows Server 2022 or later versions.
  • The .NET Framework version 4.7.2 or a later version. Download .NET Framework.
  • MySQL ODBC 5.1 Driver and connectivity to the MySQL databases that you want to migrate. You can install the MySQL from the MySQL Web site. For information about connectivity, see Connecting to MySQL (MySQLToSQL).
  • Access to and sufficient permissions on the computer that hosts the target instance of SQL Server where you're migrating database objects and data. For more information, see Connecting to SQL Server (MySQLToSQL).
  • For Azure SQL Database projects, access to and sufficient permissions to the instance of Azure SQL Database where you're migrating database objects and data. For more information, see Connecting to Azure SQL Database (MySQLToSQL).
  • 4 GB of RAM recommended.

Install SSMA for MySQL client

SSMA is a Web download. To download the latest version, see the SQL Server Migration Assistant download page.

To install the SSMA client:

  1. Double-click SSMAforMySQL_n.msi, where n is the build number.

  2. On the Welcome page, select Next.

    If you don't have the prerequisites installed, a message appears indicating that you must first install the required components. Make sure that you have installed all the prerequisites before running the installation program again.

  3. Read the End-User License Agreement. If you agree, select I accept the agreement, and then select Next.

  4. On the Choose Setup Type page, select Typical.

  5. On the Ready to Install page, you can enable or disable telemetry and automatic update checks every time the tool starts. Select Install to start the installation.

Important

Please uninstall all prior versions of SSMA for MySQL before installing the new version.

The default installation location is C:\Program Files\Microsoft SQL Server Migration Assistant for MySQL.

Related content

  • Last updated on