Transfer a MySQL database to MSSQL Server

Published December 29th, 2023 by Oanh Do

Use case: we receive data in MySQL and we need to move it to our SQL database server for data migration. SQL Server Migration Assistant for MySQL (SSMA) is a great tool to achieve it and it is quite simple to use.  Link to download SSMA https://www.microsoft.com/en-us/download/details.aspx?id=54257 Prerequisites: MySQL ODBC driver is installed. An e