Microsoft SQL 2008 Generate script for the whole database

Today I come across a task that require me to backup all the scripts in ms sql server 2008 R2. I take a look at all possibilities then come into this solution:

1. Right Click the database that we wish to generate script from, then select -> tasks -> generate scripts…

Create Script of the whole database

2. Then it will open up the wizard to create the script
wizard open

3. We also can specify the script for whole database or even to specific tables/stored procedures

4. Other than that we also can specify our preferred output type
output type preferrence

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s