The circle of life – ** .Net – Training – MOSS **

  • Past Post

  • Vistor Locations

  • Advertisements

Need to script one object per file in SQL Server 2005

Posted by Clayton James on February 9, 2007

For some strange reason beyond comprehension the SQL Server 2005 team removed the ability to script out one object per file. The only option is to script out selected objects into one (large) file.

I would script out one object per file when I felt it was time to add my SQL Server objects to source control. This easily allowed my to script out my schema objects in their own file which I then simply added to a Database project and bound to source control.

Anyway, I then came across scriptio. A cool utility (with source) that allows you to….yes, script out one sql object per file 🙂

It uses click once deployment to install and manage updates also, very cool.


2 Responses to “Need to script one object per file in SQL Server 2005”

  1. Endy said

    Great post.. thanks for sharing 😀

  2. A great deal of teenagers are previously planck
    satellite wikipedia seeing satellite Television totally free
    of charge quietly at property by making use of some techniques which I will be sharing.
    The etiquette of business could be the group of written and unwritten rules of conduct which make social interactions run more smoothly.
    Your family will be the last one to know or believe that you have an important
    award, that your particular company is successful or that you’re helping a huge number of people.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: