sql server 转mysql_将SQL Server数据库转换为MYSQL数据库

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)

解决方案

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 mssqlmysql, 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)