2005: Script Each Object To Own File

21 Jul 2006 2:50 AM

Jordan S.

Is it possible in SQL Server 2005 Management Studio - to script multiple
database objects; each to its own file (and NOT all into one single file)?
This was obvious to accomplish in EM, but I didin't see how to do it in
SSMS. What did I overlook?

Thanks!

21 Jul 2006 5:09 AM

P. Ward

Unfortunately you are not missing something; the one file for each object
option is not currently available in SQL Server Management Studio.

The following post illustrates how you can create an application using the
SQL Server Management Objects to script each object to an individual file
http://www.wardyit.com/blog/blog/archive/2006/07/21/133.aspx.

The other option is to download the Scrtipto utility that Bill Graziano
(http://www.sqlteam.com/Site/About.asp#graz) has developed from
http://www.sqlteam.com/publish/scriptio/. For more details regarding Scripto
refer to http://weblogs.sqlteam.com/billg/archive/2005/11/22/8414.aspx.

HTH

- Peter Ward
WARDY IT Solutions

Show quote

"Jordan S." wrote:

> Is it possible in SQL Server 2005 Management Studio - to script multiple
> database objects; each to its own file (and NOT all into one single file)?
> This was obvious to accomplish in EM, but I didin't see how to do it in
> SSMS. What did I overlook?
>
> Thanks!
>
>
>