2

What is the best, simplest way to transfer a SQL Server db to MYSQL?

Improve this question

3 Answers 3

Reset to default
2

The MySQL GUI Tools comes with the MySQL Migration Toolkit which will allow you to easily automate the task of transferring your database to MySQL.

The MySQL Migration Toolkit is free.

Not everything is transferable, and for the best results, you are always better of transferring manually.

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

I used this tool (albeit with an MS Access legacy DB) and have good experience with it
This sounds like it should work for me - I only require the database schema (all tables).
0

U can create a script file of your MSSQL db, then run it in MySQL with the help of MySQL GUI Tools

Improve this answer

2 Comments

How does this cope with different data types between the two DBs, etc ?
@kevinw: as in all things, you should have to double-check to ensure data types were converted appropriately.
0

Use an ETL tool.

Improve this answer

2 Comments

DTS? DTS was replaced by SSIS in SQL Server 2005, and was not "excellent" before that.
Thanks for the correction, John. Apparently I'm basing my opinion on old information.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.