MySQL to SQL Server Migration :(

[MKVAB]

Hey there folks. I have a MySQL table script that I need to create in SQL Server 2000. I figured I had 2 options...
1. manually alter the script so it is SQL Server compliant (changing data types and such)
2. create a MySQL DB, create the tables there and then import into SQL Server

Being that I wasn't up to manually altering a few hundred make table scripts I chose option 2. As far as the import goes, no problem. But when imported into SQL Server (using a DTS package) I noticed several things that gave me pause:
1. Default values were not imported
2. some int data types were changed to decimal (int types above 4 I think)
3. unique key constraints not imported
4. auto increment numbers not set to identity

This is all I've notice thus far.

So, here's the question, anybody know of a MySQL to SQL Server migration tool that would import more of the table attributes???? Or, an idea of something that would work better then using a DTS package to do the import?

Ideas?!?!
Suggestions?!?!
HELP!!!

Thank you!
-Mary Klaire

 

[MKVAB]

Found a tool! We used a tool called SQL Porter. It brought in all the keys and defaults. This works much better than simply using DTS packages in SQL Server to import the tables.

There is a free version ($500 for full version). The only drawback to the free version is that you can only import 5 tables at a time. Kinda a pain but better than manually changing all the table attributes.

Here's the site:

http://www.realsoftstudio.com/orderonline.php

-Mary Klaire

 

[hos2]

changing from mysql to sql server ?? I thought that procedure would only be necessary the other way