2011-11-08

Microsoft SQL Server Migration Assistant

SQL Server Migration Assistant (SSMA)

The SSMA blog annouces the new version 5.3.

MySQL (SSMA for MySQL Client)

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 SQL Server or SQL Azure.
  • Convert the MySQL database objects to the SQL Server or SQL Azure objects.
  • Load the objects into SQL Server or SQL Azure.
  • Migrate data to SQL Server or SQL Azure.

Prerequisites

SSMA for MySQL is designed to work with MySQL 4.1 or later versions and all editions of SQL Server 2005, SQL Server 2008, SQL Server “Denali” and SQL Azure.
Before you install SSMA, make sure that the computer meets the following requirements:
  • Windows XP SP2 or later versions, or Windows Server 2003 SP1 or later versions.
  • WinZip, or a similar utility, to extract files from a Zip file.
  • Microsoft Windows Installer 3.1 or a later version.
  • The Microsoft .NET Framework version 2.0 or a later version. The .NET Framework version 2.0 is available on the SQL Server product media. You can also 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
  • Connectivity to the instance of SQL Server / SQL Azure where you will be migrating database objects and data
  • In case of SQL Azure projects, Connectivity to the instance of SQL Azure where you will be migrating database objects and data.
  • 1 GB RAM recommended.

Installing SSMA for MySQL Client

SSMA is a Web download. To download the latest version, see the SQL Server Migration Tools product page
After you download the latest version, you must extract the installation files before you can install SSMA.
To install the SSMA client
  1. Extract all files from the SSMA compressed file
    If you are using WinZip, depending on the version that you have, you can either double-click the file, or right-click the file and select Extract All or Open in WinZip. Follow the instructions in the WinZip user interface to extract the files. If you are using another extraction utility, follow the directions for that utility.
  2. Double-click SSMA for MySQL n.Install.exe, where n is the build number.
  3. On the Welcome page, click Next.
    If you do not have the prerequisites installed, a message will appear indicating that you must first install the required components. Make sure that you have installed all the prerequisites before running the installation program again.
  4. Read the End User License Agreement. If you agree, select I accept the terms in the license agreement, and then click Next.
  5. Read the Usage Report Settings page, select or clear the feature reporting box, and then click Next.
  6. On the Choose Setup Type page, click Typical.
  7. Click Install.
Important
  1. SSMA for MySQL v5.1 product can be installed side by side (SxS) with older versions of SSMA Product (versions prior to SSMA for MySQL v5.0. SSMA for MySQL v5.0 has to be uninstalled before installing SSMA for MySQL v5.1).
  2. You can install the SSMA for MySQL v5.1 product successfully even though if there are any earlier versions of product already installed (SSMA for MySQL 2005 v4.2 or earlier/SSMA for MySQL 2008 v4.2 or earlier).
  3. Each of these SxS products can be uninstalled separately and are independent of each other.

The default installation location is C:\Program Files\Microsoft SQL Server Migration Assistant for MySQL.
On 64-bit Windows machine the product is installed in C:\Microsoft SQL Server Migration Assistant for MySQL.

Licensing SSMA

To use SSMA, you must download a registration key. To help you with the registration process, a License Key Required dialog box opens the first time that you start the SSMA program. Use the following instructions to download a license key and associate the key with SSMA.
To license SSMA
  1. Click Start, point to All Programs, point to Microsoft SQL Server Migration Assistant for MySQL, and then select Microsoft SQL Server Migration Assistant for MySQL.
  2. In the License Management dialog box, click the license registration page link.
  3. On the Sign In Web page, enter your Windows Live ID user name and password, and click Sign In.
    A Windows Live ID is a Hotmail e-mail address, MSN e-mail address, or Microsoft Passport account. If you do not have one of these accounts, you will have to create a new account. To create a new account, click the Sign up now button.
  4. On the SQL Server Migration Assistant for MySQL License Registration Web page, fill in at least the required fields, which are marked with a red asterisk, and then click Finish.
  5. In the File Download dialog box, click Save.
  6. In the Save As dialog box, locate the folder that is shown in the License Management dialog box, and then click Save.
    The default location is C:\Documents and Settings\user name\Application Data\Microsoft SQL Server Migration Assistant\MySQL.
  7. In the License Management dialog box, click Refresh License.

      HTMLCode

      HTMLCode Content