mySQL to SQL Server 2000

Hi there,

i have a forum that uses php and mySQL.

I have done a backup of the database which saves as a .sql file.

I need to transfer my forum to a server running SQL Server 2000, but the backup file will not restore the database for me.

I presume that i will need to convert the data in some way - but how and with what??

any help appreciated

Use DTS to copy data, and rebuild the database structure manually.