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,894 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.
495 questions
0 comments No comments
{count} votes

2 additional answers

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

    Thank you for your prompt response. :D

    0 comments No comments

  2. Sreeju Nair 11,856 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 No comments