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
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.