mysql dump

This is probably a silly question but here goes...

When you dump a mysql table or db, is that dump file compatible with Micro$oft SQL?, ie, can I give it to someone running ms-sql and they can import it?

If not, what else can I do to give them table contents?
LVL 17
psimationAsked:
Who is Participating?
 
lokeshvConnect With a Mentor Commented:
yes u can import all the SQL if u havent used any specific feature for MySQL..


you can also dump the data in CSV format and can import it in MS SQL...


Hope this helps..


LK
0
 
harwantgrewalCommented:
Ya when ever you dump as mysql it gives you a txt file you can directly import the file using the MSSQL import.

Harry
0
 
psimationAuthor Commented:
thanks
Seems to be enough people to agree on that issue. Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.