Migrating MySQL to SQL Server

Paul Andrews 21 Reputation points
2022-10-04T13:32:26.457+00:00

I am reading your guide on how to migrate MySQL to SQL Server and it states :

"Verify that your source environment is supported. Currently, MySQL 5.6 and 5.7 are supported."

So any newer version of MySQL won't work then? Only those two versions?

Thanks in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,639 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
490 questions
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Paul Andrews 21 Reputation points
    2022-10-04T13:42:13.053+00:00

    Thank you for your prompt response. :D

    0 comments
  2. Sreeju Nair 11,606 Reputation points
    2022-10-04T13:46:09.59+00:00

    See the following from the SQL Server Migration Assistant (SSMA)

    "SSMA for MySQL is designed to work with MySQL 4.1 or later versions and all editions of SQL Server 2012 or later, and Azure SQL Database."

    Refer: https://learn.microsoft.com/en-us/sql/ssma/mysql/installing-ssma-for-mysql-client-mysqltosql?view=sql-server-ver16#prerequisites

    I believe that documentation you are referring to, needs to be updated, not sure.

    Hope this helps

    0 comments