ROB — Thu, 13 Jun 2002 16:15:35 +0000

could you not just use mysqldump to dump the table as sql commands and use that to create the MS SQL database?

i'm not sure if mysqldump dumps mysql specific functions or not... it may be worth a try though... even though, microsoft has a problem following standards so even ansii sql may not import correctly into a microsoft database.

Peter J. Boettcher — Wed, 12 Jun 2002 15:49:07 +0000

Unfortunately I don't think there is a native import filter for mySQL --> MSSQL.

So you'll have to follow Mark's advice and export your tables into text files, then create the empty table(s) in MSSQL and import data into them using the text filter and your text files. With Enterprise Manager this is easy, just right-click on your database and select import, then for the datasource select text, and select the file. Just follow the directions after that, it's really simple.

mairving — Wed, 12 Jun 2002 14:57:48 +0000

If you are transferring the data, you can run a select statement from MySQL like:

<?php
SELECT * from table_name into outfile \"/home/username/tablename.txt\"
?>

This will only export the data as a space delimited .txt file which can be imported into SQL Server. I am not sure about the import part but I am sure that Peter can tell you.

Note: You will have to export every table.