SQL Server Management Studio - one file per object

26 Jun 2006 3:56 PM

jlccd@newsgroups.nospam

Using SQL Server Enterprise Manager objects could be selected, stored
procedures, tables, triggers... and scripted to individual files.

We are in the process of migrating to SQL Server 2005 and we are all getting
familiar with Management Studio. Typically all the objects were scripted to
individual files which were then added to source control.

How can we accomplish the same task in Management Studio.

SQL Server Management Studio (2005) - script objects: ne file per object

26 Jun 2006 6:07 PM

Jasper Smith

You can't using SSMS. You can download Scriptio + source code from
http://weblogs.sqlteam.com/billg/archive/2006/06/13/10208.aspx
This is a SMO utility which allows scripting to individual files

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com

Show quote

"jlccd@newsgroups.nospam" <jdamukai***@p2plink.com> wrote in message
news:uKXzIlTmGHA.3736@TK2MSFTNGP05.phx.gbl...
> Using SQL Server Enterprise Manager objects could be selected, stored
> procedures, tables, triggers... and scripted to individual files.
>
> We are in the process of migrating to SQL Server 2005 and we are all
> getting familiar with Management Studio. Typically all the objects were
> scripted to individual files which were then added to source control.
>
> How can we accomplish the same task in Management Studio.
>
>
>
>
> SQL Server Management Studio (2005) - script objects: ne file per object
>
>

12 Jul 2006 4:23 AM

Paul A. Mestemaker II [MSFT]

You can script multiple objects to a single file by highlighting multiple
objects on the Summary Page (F7). We do not currently support scripting
each object to a separate file, however we have heard this request and we
will try to do something about it in the near future.

This has been filed on our Microsoft Connect customer portal:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125633

You can track the progress of it throughout the product lifecycle.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server
http://blogs.msdn.com/sqlrem/

Show quote

"jlccd@newsgroups.nospam" <jdamukai***@p2plink.com> wrote in message
news:uKXzIlTmGHA.3736@TK2MSFTNGP05.phx.gbl...
> Using SQL Server Enterprise Manager objects could be selected, stored
> procedures, tables, triggers... and scripted to individual files.
>
> We are in the process of migrating to SQL Server 2005 and we are all
> getting familiar with Management Studio. Typically all the objects were
> scripted to individual files which were then added to source control.
>
> How can we accomplish the same task in Management Studio.
>
>
>
>
> SQL Server Management Studio (2005) - script objects: ne file per object
>
>