Trying to convert a mySQL database to MSSQL. Using Import data in SQL Server
2000, it works fine, however I get no primary keys defined on any of the
tables, am I missing something? Or is there a tool that would do this?

Many thanks.

Oops, forgot to mention that I'm using the MySQL 3.51 ODBC connector in the
import process.

Hello Michael,


Nope you are missing nothing. There is no way in DTS to do this, likewise
you cannot do this with an Access DB. The only DB type that you can do this
with is SQL Server --> SQL Server.

A solution would be to read the metadata for the keys and indexes from MySQL
and bulid the appropriate SQL Server equivalent statements and apply them.



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hello Allan,

Thanks for the info, was hoping that I would not need to write a bunch of
code to get this information out of the mySQL database and then parse it
against SQL Server. Looks like a good use of a late night coding, perhaps
I'll throw the code out on CodeProject once I'm done.........

Know that there are converters, but why spend hundreds when you can write
it yourself in an evening.........