MY SQL to MS SQL

[Anon]

Hi,

can anyone please help me move my db from MYsql to MSsql?

any comments are more than welcome, please email me.

thanks a lot,
adam

[Anon]

I've only used MS_SQL Server a few times but..

It has an import feature where you can import ODBC data sources into a new DB. So you could set up a MySQL ODBC datasource of your existing DB, and then use that import feature??

Cheers,
Sean.

[Anon]

Sean is heading in the right direction, you should go download myodbc from mysql.com, install it and create an odbc source on the ms-sql machine. MySql and MS-sql do not have all the same datatypes so if you use their import wizard, be sure to look and see how it is designing the tables as it may cause problems.