how to generate script in database

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008

how to generate Script in sql server 2008 databse,
i want to genereate procedure script if procedure is alter mode then it should be create alter

Posted 9-Sep-12 20:50pm

DINESH K MAURYA

Add a Solution

Comments

manognya kota 10-Sep-12 2:51am

Can you be little more clear please

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Prasad_Kulkarni · Accepted Answer · 2012-09-09T20:57:00

Solution 2

Have a look:

Pinal Dave: Create Script[^]

MSDN:
How to: Generate Create Scripts[^]
Generate a Script (SQL Server Management Studio)[^]

..and lot more similar threads here[^]

Posted 9-Sep-12 20:57pm

Prasad_Kulkarni

Comments

Mohamed Mitwalli 10-Sep-12 3:01am

5+

Prasad_Kulkarni 10-Sep-12 3:03am

Thank you Mohamed!

__TR__ 10-Sep-12 3:10am

+5

Prasad_Kulkarni 10-Sep-12 3:10am

Thank you TR!

_Amy 10-Sep-12 3:18am

5'ed. :)

Prasad_Kulkarni 10-Sep-12 3:26am

Thank you Amit! but where's FIVE ??:)

_Amy 10-Sep-12 3:34am

Oh I missed it.. Now given. :)

Mohamed Mitwalli · Accepted Answer · 2012-09-09T21:00:00

Solution 3

Hi ,
Right Click on Database name on object explorer select Tasks then Generate Script Click Next Then select the objects you want to Script it or leave it for the whole Database
Next Click on Advanced Choose Script Drop and Create Version of sql select Type of data to script You will find alot options specify what you need then click ok then Choose save to new query then Next Next Finish
http://blog.sqlauthority.com/2011/05/07/sql-server-2008-2008-r2-create-script-to-copy-database-schema-and-all-the-objects-data-schema-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/[^]
Best Regards
M.Mitwalli

Posted 9-Sep-12 21:00pm

Mohamed Mitwalli

Comments

__TR__ 10-Sep-12 3:09am

+5

Mohamed Mitwalli 10-Sep-12 3:11am

Thanks TR :)

Prasad_Kulkarni 10-Sep-12 3:11am

5'ed :D

Mohamed Mitwalli 10-Sep-12 3:11am

Thanks Prasad :)

_Amy 10-Sep-12 3:18am

5'ed. :)

Mohamed Mitwalli 10-Sep-12 3:40am

Thanks Amy :)

Mohamed Mitwalli 10-Sep-12 3:44am

it seems i didn't get the points for your voting :( lol

_Amy 10-Sep-12 4:51am

oh! Now I have given. :)

Mohamed Mitwalli 10-Sep-12 5:19am

Thanks :)

Dev-0001 10-Sep-12 4:10am

5

Mohamed Mitwalli 10-Sep-12 4:11am

Thanks Dev

_Amy · Accepted Answer · 2012-09-09T20:53:00

Solution 1

Here you go with the links which demonstrating the same:
http://myvsdotnetstuff.blogspot.in/2011/11/sql-server-2008-generate-script-of.html[^]
http://sqlblog.com/blogs/eric_johnson/archive/2010/03/08/script-data-in-sql-server-2008.aspx[^]
http://blog.sqlauthority.com/2009/07/29/sql-server-2008-copy-database-with-data-generate-t-sql-for-inserting-data-from-one-table-to-another-table/[^]
http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/[^]

--Amit

Posted 9-Sep-12 20:53pm

_Amy

Comments

Mohamed Mitwalli 10-Sep-12 3:01am

5+

_Amy 10-Sep-12 3:17am

Thanks Mohamed. :)

__TR__ 10-Sep-12 3:09am

+5

_Amy 10-Sep-12 3:17am

Thanks _TR_. Your good name please? :)

Prasad_Kulkarni 10-Sep-12 3:11am

5'ed :D

_Amy 10-Sep-12 3:18am

Thanks Prasad. :)