Convert a SQL Server database to MYSQL database

Question

Alright so I want to convert an already exist SQL Server database (2005) to a MYSQL database.

There is nothing extraordinary to be done

The only things I need to achieve is

• Recreate the tables
• Transfer data
• Relationships would be nice but not necessary

No views, no sprocs, no functions.

Any easy way to do this.

Also do you know of any Free DST (Database Synchronization Tool) which would let me do

• MSSQL to MYSQL
• MYSQL to MYSQL
• MSSQL to MSSQL (I know there is SQL Delta for this - not free though)

Answer 1

Have you checked out these tools?

http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html

Answer 2

Make sure to set the correct SQL Mode in MySQL, the MSSQL setting sounds good to me. With this setting, MySQL works pretty well with ANSI SQL, T-SQL looks like ANSI so you will be fine.

Answer 3

have you looked at pentaho's kettle (or pentaho data integration)? http://kettle.pentaho.org/

we use it to copy over and keep in-synch disparate database systems, such as mssql<->mysql, which seems to be what you are asking for.

kettle is even more powerful than that, allowing you to query ldap databases, straight text files, etc...

its diagramming tool is similar in look and feel to microsoft's dts (but more powerful, imho)