I have a
mysqldump output of a fairly large (by measure of doing things manually) database saved in a text file. Does anybody know of a (free) way to use this to build a database in MS SQL? I'm specifically using SQL Server 2008.
I used something like this:
Assuming you have a table (TBL1245) in a database (DB4711) to hold all the fileds of your datadumo-file. if you have to change delimiter see in ms-bol for the bcp parameters.
You could reload that data back into MySQL and execute mysqldump using the following:
mysqldump -h... -u... -p... --compatible=mssql > MSSQL_Compatible_Data.sql
Here is what the mysqldump --help --verbose says on that
--compatible=name Change the dump to be compatible with a given mode.
Give it a Try !!!