How can i export MS Sql Server Database dump and Import that Into Mysql Database?

Question

I am in a strange situation now, I am very new to MS Sql server Database think. Am working on mysql now. I have a databse in MS Sql server database and i want to create a same database in mysql. I try to generate script from MS Sql server into a file dump.sql now that i need is i cannot use that file to import into mysql database.

Can some one tell me how can i use the generated script to create a database in mysql?

Or is there any other way i cano directly get mysql formate script from MS Sql server ?

thank you in advance.

jimmy · Accepted Answer · 2011-11-18 09:01:56Z

1

I have found one page where i can use the script from ms sql generated scripted which give mysql Script.

http://www.burrist.co.uk/mstomy.php

answered Nov 18, 2011 at 9:01

jimmy

8,42111 gold badges39 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

gbn · Accepted Answer · 2011-11-16 10:29:34Z

0

Create the table in MySQL manually (using the CREATE TABLE from SQL Server as a template)
Export the data as CSV from SQL Server
Import the data into MySQL from the CSV

answered Nov 16, 2011 at 10:29

gbn

434k84 gold badges602 silver badges690 bronze badges

1 Comment

jimmy Over a year ago

It does not work for me. I cannot directly import, an exported CSV file from ms SQL into mysql. Thank you for the help

Collectives™ on Stack Overflow

How can i export MS Sql Server Database dump and Import that Into Mysql Database?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related