| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.collection | ms.custom | helpviewer_keywords | |||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Installing SSMA for MySQL client (MySQLToSQL) |
Learn about installation prerequisites for the SQL Server Migration Assistant (SSMA) for MySQL client and how to install. |
cpichuka |
cpichuka |
randolphwest |
07/10/2023 |
sql |
ssma |
install-set-up-deploy |
|
|
|
The SSMA for MySQL client consists of the program files that perform the following tasks:
- Connect to a MySQL database.
- Connect to an instance of [!INCLUDE ssNoVersion] or [!INCLUDE ssazure-sqldb].
- Convert the MySQL database objects to the [!INCLUDE ssNoVersion] or [!INCLUDE ssazure-sqldb] objects.
- Load the objects into [!INCLUDE ssNoVersion] or [!INCLUDE ssazure-sqldb].
- Migrate data to [!INCLUDE ssNoVersion] or [!INCLUDE ssazure-sqldb].
This article provides the installation prerequisites and instructions for installing SSMA for MySQL client.
SSMA for MySQL is designed to work with MySQL 4.1 or later versions and all editions of [!INCLUDE ssNoVersion] 2012 or later, and [!INCLUDE ssazure-sqldb].
Before you install SSMA, make sure that the computer meets the following requirements:
- Windows 7 or later versions, or Windows Server 2008 or later versions.
- [!INCLUDE msCoName] Windows Installer 3.1 or a later version.
- The [!INCLUDE msCoName] [!INCLUDE dnprdnshort] version 4.7.2 or a later version. You can obtain it from the .NET Framework Developer Center.
- 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 [!INCLUDE ssNoVersion] where you are migrating database objects and data. For more information, see Connecting to SQL Server (MySQLToSQL).
- For [!INCLUDE ssazure-sqldb] projects, access to and sufficient permissions to the instance of [!INCLUDE ssazure-sqldb] where you are migrating database objects and data. For more information, see Connecting to Azure SQL Database (MySQLToSQL).
- 4 GB of RAM recommended.
SSMA is a Web download. To download the latest version, see the SQL Server Migration Assistant download page.
To install the SSMA client:
-
Double-click SSMAforMySQL_n.msi, where n is the build number.
-
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.
-
Read the End-User License Agreement. If you agree, select I accept the agreement, and then select Next.
-
On the Choose Setup Type page, select Typical.
-
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.