tool for migration of MYSQL to MSSQL | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

tool for migration of MYSQL to MSSQL

Can any one explain me the procedure for migrating mysql databases, their objects and data to MSSQL Server.If any free tool exist for the same pls give me the link.
As of I know there is no such tool to migrate the MYSQL to MSSQL and this technethttp://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx article will help you a lot. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I have read this article ut I am wondering how all the dbs from mysql will be transferred to mssql server.DTS has the facility to take one db at a time.
I am wondering whether this method will do the migration by making the dbs in single user mode or not.moreover will this method transfer the logins and subsequently map the sid of user to the sid of logins.
There is no direct method like using DTS between MYSQL and MSSQL, you must deploy the methods mentioned on the about technet article. I haven’t got a chance to involve practically in such migration, you may wait for other members opinion and experience. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>