mysql to mssql converter

[Naoise]

I need to export a mysql database to a mssql one. Can anyone recommend any good freeware to do this. I tried DTS via mssql but there are datatype problems and primary key data is not being transfered. Any help appreciated.

 

[TonyGroves]

I don't know of any free tools to do that, but one solution might be to do a mysqldump of the MySQL database, and text-edit the resulting file to suit before importing it into MS SQL. Alternatively, you could just use that technique on the table structures, and transfer data via CSV files.

Go n-éirí an bóthar leat.

 

[bhp]

Or Simply use the DTS wizard in sql server and use an odbc connection the only thing you need to do is install the MYSQL drivers !!!