How to Migrate MySQL Database to MS SQL Server Database

Database migration is the process of transferring data between two database engine. The process includes schema migration, Synchronization of database and data migration between MySQL database to SQL Server.

Step #1 Download and Install SQL Server Migration Assistant for MySQL

Step #2 Download and Install Connector/ODBC for mysql

Step #3 Open SQL Server Migration Assistant
a) Connect MySQL Database
b) Connect SQL server
c) Migrate Schema
d) Synchronize Database
e) Migrate database
Follows the steps show in video
Done !!

[sherek]

Thanks a lot man, it was very useful to me!I appreciate that!

[danieldlr]

Thanks a lot, a very helpfull video!!

[aslalshaja]

thanks a lot... its very useful
can you suggest me how to auto sync MySQL Database to MS SQL Server Database

[charbelsalles]

To com problema mysql 8.0 para sql server 2019, alguns dados estão cortando parte do texto.

Exemplo nome, muitos estão corretos outros cortando.

CPF a mesma coisa, tem alguma ideia de como ajustar isso ?

[gurdialmanj]

system error 126 myodbc8w.dll error copied the file to desired location but error still persist

[akramsherkhan]

can u please help me to migrate data from sql server to ms sql

[chitwanhumad]

Can we migrate procedures, functions and triggers as well?

[jamols]

Why is my Connect to Mysql Tab not showing?

[Royals_adda]

please make video of installing of two mysql instances at a single machine