This is frustrating for a mysql user to take a database dump when they try to do the same in sql server. Here is the one of the optimal way for a mysql user working for sql server.
Right Click on database -> Tasks -> Generate Scripts..
Next -> Select the database name from a list
Under advanced scripting option-> Types of data to Script
You have 3 options to be selected here
- Schema only
- Data only
- Schema and data
Later on give the path and file name for generating the script.
Now question is how to run this script?
1. run the below command at DOS command prompt
OSQL -U <userName> -P <password> -S <serverName> -i <completepathSQLFile>
2. Open the generated script file in a query window and just run them in one go. Just like you run a simple query. But you are advised to do provided its a small sized file.