web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :

Microsoft SQL 2008 Generate script for the whole database

Andre Margono Profile Picture Andre Margono 2,602

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
selection

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


Tagged: microsoft sql, microsoft sql 2008, mssql, sql 2008, sql 2008 r2

This was originally posted here.

Comments

*This post is locked for comments