Click here to Skip to main content
14,698,403 members
Articles » Database » Database » SQL Server
Technical Blog
Posted 25 Oct 2013

Tagged as

Stats

8.6K views
5 bookmarked

Generate script from Microsoft SQL Server Management Studio

Rate me:
Please Sign up or sign in to vote.
4.80/5 (2 votes)
25 Oct 2013CPOL
Generate script from Microsoft SQL Server Management Studio.

From Microsoft SQL Server Management Studio right click on database,  a pop up menu will appear.  From popup menu select tasks > Generate Scripts. A new dialog box called Generate and Publish Scripts window will appear. This window will look like below picture.

GenerateScript_1

From this window click on next button. Choose Objects option will appear like below picture.

GenerateScript_2

Now you can either generate script for all database objects or specific object. To do this just select one option.  If you select “Select specific database objects” then you have to select the objects from list.

Now click on next button. Set scripting options will appear like below picture.

GenerateScript_3

We will save the script to a specific location, that’s way select first option. choose the file name. Now click on Advanced button. A new window will appear like below picture.

GenerateScript_4

select “schema and data” option of Types of data to script. This will generate the schema as well data. Click on OK button. Click on next button and review your selection. Then once again click on next button and it will start to generate the script. After generate script just click on Finish button.

Job done.

The post Generate script from Microsoft SQL Server Management Studio appeared first on crea8ivecode.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Sadeque Sharif
Founder Codexplorer Technologies
Bangladesh Bangladesh
I am:
Founder & Technical Head at Codexplorer Technologies.
IT Consultant at Meridian Group.

I was:
Manager (IT) at Meridian Group.
Assistant Manager (Software Division) at KDS Garment Industries Limited.
Assistant Manager (Software Division) at E-Vision Software Limited.

My blog:
crea8ivecode

My preferred work area:
ASP.NET & SQL SERVER.

My email:
sadeque.sharif@yahoo.com

Follow me:
twitter | facebook | linkedin

Comments and Discussions

 
QuestionUsing a generated script ? Pin
IanD-UK11-Feb-14 23:38
MemberIanD-UK11-Feb-14 23:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.