Scripting out DB objects

Question

Scripting out DB objects

SG-348334

Ten Centuries

Points: 1374
More actions
October 30, 2007 at 1:59 pm

#376604

In SQL 2000 there was an option to script each object to individual files.
I can't find that option in SQL2005, it only give me the option to script to one file for all objects.
Did I miss something? or am I not looking in the right place.
Thanks in advance
Susan

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

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

Vidhya Sagar SSCrazy Eights Points: 8216 More actions · Answer 1

You can do the same in 2005 also.

Go to the 4th screen of the scripting wizard, here you can select the script option then select "file per object" option , this option will script every object to a new file. I've attached a sample pic, pls check

Regards..Vidhya Sagar
SQL-Articles

SG-348334 Ten Centuries Points: 1374 More actions · Answer 2

I don't have those options...

Here's what I have in the same screen.

SG-348334 Ten Centuries Points: 1374 More actions · Answer 3

I don't have the same options as you, what is the SQL 2005 version and edition are you using?

I'm running a standard SQL 2005 with no sp's.

Thanks in advance

Susan

homebrew01 SSC Guru Points: 55548 More actions · Answer 4

Put on Service Pack 2, then you'll get it (not sure about SP1)

SG-348334 Ten Centuries Points: 1374 More actions · Answer 5

Thanks... SP2 did it.

I tried it with SP1, but still didn't see the 'per object' option.

Once I applied SP2, there it was...

Thanks again

Susan

Mayank Khatri SSCertifiable Points: 7984 More actions · Answer 6

I do see the options in SQL 2005 Dev edition service pack 2