[SOLVED] MySQL to MSSQL

Anyone know of a "FREE" tool that can migrate a MySQL database to MSSQL??: I have looked and found a few pay ones, but so far nothing free.

Thank!

dunno if this is free:-

http://www.bykeyword.com/pages/detai...load-8276.html

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder

Looks like it. I will test it and let you know. Thaks for the great find!

<blockquote id="quote"><font size="1" face="geneva, verdana, arial" id="quote">quote:<hr height="1" noshade id="quote">Originally posted by Stephen

Anyone know of a "FREE" tool that can migrate a MySQL database to MSSQL??: I have looked and found a few pay ones, but so far nothing free.

Thank!
<hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">

DTS is built into MS SQL ... aim it at the MySQL db?

Or - MySQL does a nice db dump of both schema and db contents into one script file which, with minor mods, could be run in Query Analyzer to create a db. It does not include the 'create database ..' command itself, so you can either add it or create the db first and make sure that's the active db before running the script. Will create and populate tables. Might have to do some mods, as I said, on the create table statement (references ISAM) and perhaps some of the datatypes, but global s&r will make short work of that.

Or ... how did Rob's suggestion work?

The data dump I got from MySQL was not importable into SQL. DTS does work as well, but it is a pain, and it didn't take it all. Still haven't found a completely free one.

Did you install myODBC driver?

Using the "import/export wizard" which is DTS, I found it way too easy, and not a pain in the least.

1) install myODBC driver
2) specify a System DSN aiming at the mySQL database you want to import into MS SQL
3) Run the "Import/Export" wizard.

In seconds, a new MS SQL database is created, with all data transformed and present.

myODBC driver can be downloaded from http://www.mysql.com/

more info available at:

http://www.microsoft.com/technet/tre...vg/miglamp.asp

hth,
Mike

Thanks for the info. I will give that a try!

Hi pmichael,

I've just tried your suggestion,
but how come all the primary key from mysql database gone?

Any other suggestion?

Cheers,
Hendry J