MySQL db to SQL2000 ???

[Anon]

I want to populate a SQL2k db with info from a MySQL db. any comments or sugguestions??

[neuromancer]

Well, MySQL Dump should come pretty close, other than table schema

If you rebuild your tables by hand and just run the inserts with 'SET INSERT_IDENTITY <table name> ON' then set it to OFF when your done it should be fine.