General discussion


mySQl to sql server migration

By neil30076 ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

simplest way

by Jaqui In reply to mySQl to sql server migra ...

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.

Collapse -

Well neither of them is exactly standard, so

by Tony Hopkinson In reply to mySQl to sql server migra ...

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.

Related Discussions

Related Forums