fbpx

Easiest way to generate SQL from Microsoft SQL Server database

(Last Updated On: November 18, 2010)

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!

Subscribe For Latest Updates

Sign up to best of business news, informed analysis and opinions on what matters to you.
Invalid email address
We promise not to spam you. You can unsubscribe at any time.

NOTE!

Check NEW site on stock forex and ETF analysis and automation

Scroll to Top