Solve, how to import MySQL database into sql2005

How to import MySQL database into sql2005

There are several ways online, I tried one, using SSMA for MySQL 5.2

Front desk steps are normal, to the connection sql2005 server is not connected up


My environment is that the local computer is loaded with MySQL. SQL2005 is installed on the remote server. I'm going to import a local MySQL database into the sql2005 on the server.


But it is not familiar with the sql2005, now encountered problems and do not know how to solve.

Reply to discussion (solution)

SSMA is not compatible with SQL Server

SSMA is not compatible with SQL Server


SSMA for MySQL 5.2

Reference 1 Floor xuzuning reply: The SSMA and SQL Server does not match


SSMA for MySQL 5.2


Crossing Net said, obviously is supporting sql2005

I can only judge from the error message.

I can only judge from the error message.


Well, thank you moderator

Can I export the SQL of MySQL database directly and then pour it into SQL Server

Already solved!!

