Software

Ask something
Discussion Locked

mySQl to sql server migration

0 helpful
2 replies

by neil30076

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Does anyone have experience using DTS to transform a mySQL4.1 database to SQL Server 2000.
SQL server 2000 enterprise manager refuses to connect to the mySQL db via mySQL ODBC 3.51, and throws a 'serious error has occured msg' each time. ODBC admin runs and test connects ok.
Any ideas?

2 replies

by jaqui

do a db dump, with full create and sql inserts from the mysql db.
then run the created file on the m$ sql server as an sql query.
entire db created and filled.

by tony hopkinson

to be quite honest I wouldn't even have tried.
I'd have dumped mysql to text and imported from it then squared it up with sqlserver itself with a few scripts and may be a stored procedure or two.

This discussion is closed to new replies.