MySQL to SQL Server

1 download Microsoft SQL Server Migration Assistant for MySQL.

2 If you are connecting to a remote database, be aware

MySQL: Change the host in the user table in database named MySQL to%: Update user set host = '% ' where host= ' localhost '; Password is empty it's best to use this method

Refer to a different approach: http://www.2cto.com/database/201205/132457.html.

Sqlserver:http://www.2cto.com/database/201310/249976.html finally pay attention to shutting down the firewall or adding SQL Server programs into the Firewall trust.

3 Conversion Tutorial http://yrq205.blog.163.com/blog/static/47672140201210612556145/

Note Create a new database with the same name in SQL Server in advance.

MySQL to SQL Server