Easiest way to generate SQL from Microsoft SQL Server database
Use:
In SQL Server Management Studio right-click your database and select Tasks / Generate Scripts. Follow the wizard and you’ll get a script that recreates the data structure in the correct order according to foreing keys. If you combine it with that script for the inserts you’ll get pretty much what mysqldump produces.
TIP: In the final step select “Script to a New Query Window”, it’ll work much faster that way.
http://serverfault.com/questions/147638/dump-microsoft-sql-server-database-to-an-sql-script
Use:In SQL Server Management Studio right-click your database and select Tasks / Generate Scripts. Follow the wizard and you’ll get a script that recreates the data structure in the correct order according to foreing keys. If you combine it with that script for the inserts you’ll get pretty much what mysqldump produces.
TIP: In the final step select “Script to a New Query Window”, it’ll work much faster that way.
Source:
http://serverfault.com/questions/147638/dump-microsoft-sql-server-database-to-an-sql-script
NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!
