Generate object scripts

Question

Generate object scripts

Ben Fidge

SSC Eights!

Points: 832
More actions
March 22, 2004 at 1:40 pm

#162076

Apologies if this has been brought up before, I couldn't find anything about it anywhere.
How do you programmatically generate object scripts, the same as you can with Enterprise Manager?
Is there a MS shipped stored procedure that does this?
Thanks
Ben

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

No, most of it is done using DMO there are examples to do bits and pieces via both DMO and TSQL around here but I have not seen anything to do all either way.

Babou SSC Enthusiast Points: 137 More actions · Answer 2

number of object scripting procedures/queries published in sql server central itself. But they works on isqlw. if you want to have like one in EM, then it is difficult to get.

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 3

there is a sqldmo example for this delivered if you have checked for example-files to be installed.

It will need to be modified because it is just a starting example.

You will have to play around with the scripting-bitmap-settings for each of the objects you want to script.

Now all my dev-db's are scripted every day and all my QA- and prod-db's are scripted at least once a week.

Ofcourse it just states schema and not data.

It does not provide stuff for encrypted objects.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Ben Fidge SSC Eights! Points: 832 More actions · Answer 4

Thanks guys,

Your responses have been very informative.

Ben

Jeff Moden SSC Guru Points: 1004343 More actions · Answer 5

Actually... there is a way if you want to generate the scripts for ALL the objects in a database. Check out the following URL...

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q220/1/63.asp&NoWebContent=1

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 6

Very nice

Many have been searching for this and (like I did) build their own sqldmo-solution.