mysql dump

Posted on 2002-04-11
Last Modified: 2006-11-17
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?
Question by:psimation

Accepted Solution

lokeshv earned 25 total points
ID: 6933283
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..


Expert Comment

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

LVL 17

Author Comment

ID: 6933551
Seems to be enough people to agree on that issue. Thanks

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PHP strings vs array errors 13 33
Loop through all records or search for one specific record when checking if email exists 6 40
parse url to form? 7 25
Log in through ID 5 18
I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
This article discusses four methods for overlaying images in a container on a web page
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to dynamically set the form action using jQuery.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question