How to migrate export MySQL Database to SQL Server

Como migrar exportar Banco de Dados MySQL para SQL Server
How to migrate export MySQL Database to SQL Server

Microsoft creates a tool that exports data from MySQL to SQL Server, the tool name is Microsoft SQL Server Migration Assistant (SSMA) to MySQL is a tool to automate the migration of MySQL database to SQL Server.

download the tool

Global vision

SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from MySQL to SQL Server. SSMA automates all aspects of migration including migration analysis, schema evaluation and SQL statement conversion, data migration as well as migration testing.

SSMA for MySQL v5.2 is designed to support migration from MySQL 4.1 and above to all editions of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Azure.

System requirements

Supported operating systems: Windows 7, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows Vista, Windows XP

Supported operating systems: Windows 7, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows Vista, Windows XP

 

Requirements for HSE for MySQL Client:

  • Microsoft Windows Installer 3.1 or a later version.
  • Microsoft. NET Framework version 2.0 or a later version. You can get it from the Development Center. NET Framework.
  • MySQL Connector / ODBC v5.1
  • Sufficient access and permissions on the computer hosting the target instance of SQL Server.
  • 1 GB of RAM.

SSMA Requirements for the MySQL Pack Extension:

  • SQL Server 2005 or higher.
  • Microsoft Windows Installer 3.1 or a later version.
  • MySQL Connector / ODBC v5.1.

Instructions

After downloading, you must extract the installation files before installing SSMA for MySQL.

 

Installing HSE for MySQL

  1. Double click on HSE for MySQL exe.
  2. On the 'Welcome' page, click Next .
  3. If you do not have the prerequisites installed, a message appears indicating that you must install required components first. Make sure you have installed all the prerequisites, and then run setup again.
  4. Read the User License Agreement. If you agree with the terms, please select "I accept the agreement" option and click Next .
  5. Read the 'Report Usage Settings' page, check or uncheck the Resource reports box, and then click Next .
  6. On the 'Choose Installation Type' page, click typical .
  7. Click Install .

In addition to the SSMA program files, you must also install the SSMA for MySQL Extension Pack on the SQL Server machine. Installing SSMA for MySQL Extension Pack Note: SSMA for MySQL Extension Pack is not supported on Windows XP. 

 

  1. Double-click SSMA to MySQL Extension Pack.exe file.
  2. On the 'Welcome' page, click Next .
  3. Read the User License Agreement. If you agree with the terms, please select "I accept the agreement" option and click Next .
  4. On the 'Choose Installation Type' page, click typical .
  5. On the "Ready to Install" page, click Install .
  6. On the 'Completed the first step of installation' page, click Next . A new dialog box will appear, in which you select the SQL Server instance for the extension package installation.
  7. Select the SQL Server instance where you will be migrating MySQL schemas, and then click Next . The default instance has the same name as the computer. The named instances will be followed by a backslash and the instance name.
  8. On the sign in page, select the authentication method and click Next . Windows authentication will use your Windows credentials to try to log into the SQL Server instance. If you select SQL Server Authentication, you must enter a SQL Server login name and password.
  9. On the next page, select Install Utilities Database n, where n is the version number, and then click Next . sysdb The database is created and user defined functions and stored procedures are created in the database. If Install Tester Database option is checked the ssmateterdb database tester will be created.
  10. To install the utilities for another instance of SQL Server, select Yea and click Next . Or, to exit the wizard, click on None .

 

Top of the page

 1,283 Total Visualizações,  1 Visualizações Hoje

4 comments

  1. Legal showed how to install, just didn't show how to migrate and other occurrences during the migration. Installation by next > next > next ok agent already know.

    1. Good morning, march,
      I didn't follow through because I ended up abandoning a migration project.
      If you have something to complement this installation send me and I'll be publishing. The community thanks you.
      Hug.

  2. Well, since the article wasn't finished… Here's a pretty half mouth sequence of what to do:

    1) After installing, run the program (on my machine it was: (“C:Program FilesMicrosoft SQL Server Migration Assistant for MySQLbinSSMAforMySql.exe”)

    2) Connect the two databases, (top menu)

    3) Select the source database on the left, and also on the lower left the destination database.

    4) Right-click on the source bank (my Sql) then click Convert Schema.

    5) In the destination bank, right-click on Synchronize

    6) then, at the top of the screen, click on: Migrate Data.

    Good luck.
    Erik
    http://www.prox.com.br

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.