Skip to content

Latest commit

 

History

History
87 lines (55 loc) · 5.94 KB

installing-ssma-components-on-sql-server-mysqltosql.md

File metadata and controls

87 lines (55 loc) · 5.94 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic ms.collection ms.custom helpviewer_keywords
Install SSMA components on SQL Server (MySQLToSQL)
Install components on the server that runs SQL Server to support MySQL database conversion with SSMA, including the SSMA extension pack and MySQL providers.
cpichuka
cpichuka
randolphwest
07/22/2024
sql
ssma
install-set-up-deploy
sql-migration-content
intro-installation
SSMA extension pack, Installation

Install SSMA components on SQL Server (MySQLToSQL)

In addition to installing SQL Server Migration Assistant (SSMA), you must also install components on the computer that is running [!INCLUDE ssNoVersion]. These components include the SSMA extension pack, which supports data migration, and MySQL providers to enable server-to-server connectivity.

SSMA for MySQL extension pack

The SSMA extension pack adds a database, sysdb, to the specified instance of [!INCLUDE ssNoVersion]. This database contains the tables and stored procedures that are required to migrate data.

Also, when you migrate data to [!INCLUDE ssNoVersion], SSMA creates [!INCLUDE ssNoVersion] Agent jobs, when server side data migration engine is used for migrating the data.

Prerequisites

Before you install the SSMA for MySQL server components on [!INCLUDE ssNoVersion], make sure that the computer meets the following requirements:

  • [!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.

  • The MySQL Client Provider, and connectivity to the MySQL database that you want to migrate. You can install providers from the MySQL product media or MySQL Web site.

  • The [!INCLUDE ssNoVersion] Browser service must be running during installation. This is used to populate a list of the instances of [!INCLUDE ssNoVersion] in the Setup wizard. You can disable the [!INCLUDE ssNoVersion] Browser service after installation.

    [!NOTE]
    If the [!INCLUDE ssNoVersion] Browser service is running, but you still don't see a list of instances in Setup, you must unblock UDP port 1434. You can use Windows Firewall to temporarily unblock the port, or you can temporarily disable Windows Firewall. You might also have to temporarily disable antivirus software. Make sure to enable firewalls and antivirus software after installation.

Install the extension pack

:::image type="icon" source="../../includes/media/download.svg" border="false"::: Download Microsoft SQL Server Migration Assistant Extension Pack for MySQL

You can install the extension pack any time before you migrate data to [!INCLUDE ssNoVersion].

Important

To install the extension pack, you must be a member of the sysadmin server role on the instance of [!INCLUDE ssNoVersion].

To install the extension pack:

  1. Copy SSMA for SSMAforMySQLExtensionPack_n.msi, where n is the build number, to the computer that is running [!INCLUDE ssNoVersion].

  2. Double-click SSMAforMySQLExtensionPack_n.msi.

  3. On the Welcome dialog box, select Next.

  4. On the End-User License Agreement dialog box, read the license agreement. If you agree, select the I accept the agreement option, and then select Next.

  5. On the Choose Setup Type dialog box, select Typical.

  6. On the Ready to Install dialog box, select Install.

  7. On the Completed the First Step of Installation dialog box, select Next.

    A new dialog box appears, in which you select the instance of [!INCLUDE ssNoVersion] for the Extension Pack installation.

  8. Select the instance of [!INCLUDE ssNoVersion] where you are migrating MySQL schemas, and then select Next.

    The default instance has the same name as the computer. Named instances are followed by a backslash and the instance name.

  9. On the connection page, select the authentication method and then select Next.

    Windows Authentication uses your Windows credentials to try to sign in the instance of [!INCLUDE ssNoVersion]. If you select Server Authentication, you must enter a [!INCLUDE ssNoVersion] login name and password.

  10. Next step requires you to set the password for a master key that will be used to encrypt any sensitive data stored in the extension pack database during server-side data migration. Provide a strong password and select Next.

  11. On the next dialog box, select Install Utilities Database n and Install Extension Pack libraries, where n is the version number, and then select Next.

    The sysdb database is created with the tables and stored procedures required for data migration (using server-side data migration engine) are created in this database.

  12. To install the utilities to another instance of [!INCLUDE ssNoVersion], select Yes, and then select Next. Or, to exit the wizard, select No.

Related content