Generate SQL Server Scripts using wizard

Madhu.b.rokkam
Posted by in Sql Server category on for Intermediate level | Points: 150 | Views : 7803 red flag
Rating: 4.33 out of 5  
 3 vote(s)

This article explains how we can generate scripts using SQL Server

Introduction

Some times we need to generate SSQl Server Scripts to generate and this can be done very easyly using a wizard

So lets see how we can do that...

Start the SQL Server Management studio, Login and select database right click as shown a wizard starts follow the simple steps

Select a Database to generate script

Click Next and select a database

Set the script options

Select the objects to script

Select the procs to script

Select the tables to script

Click finish

Thats it it will generate the script file. Hope you all like it

Page copy protected against web site content infringement by Copyscape

About the Author

Madhu.b.rokkam
Full Name: Madhu Rokkam
Member Level: Bronze
Member Status: Member,MVP
Member Since: 1/13/2011 3:13:20 PM
Country: India
Thanks and Regards Madhu
http://www.dotnetfunda.com

Login to vote for this post.

Comments or Responses

Posted by: Akiii on: 3/1/2011 | Points: 25
good one, by generating the scripts we can have a lot of time saved...

thanks
Akiii
Posted by: Madhu.b.rokkam on: 3/1/2011 | Points: 25
Thanks Akiii for your comments
Posted by: Prabhakar on: 3/5/2011 | Points: 25
Hi madhu. . .


it's a gud article . .

Login to post response

Comment using Facebook(Author doesn't get notification)