Import MySQL database into a MS SQL Server

Main reference
http://stackoverflow.com/questions/2621682/import-mysql-database-into-a-ms-sql-server

option 1. Install ODBC driver and add a sp_link
http://alvinalexander.com/blog/post/mysql/show-users-i-ve-created-in-mysql-database

option2. using mysqldump.exe and import every 300000 lines
http://stackoverflow.com/a/27945619

Advertisements