Script automation

Using SQL Server Management Studio, it is easy to create scripts for various
objects such as tables, schemas, login,... My question is: How can I
automate the process ?
I would like to write a kind of batch or script which when executed would
generate the scripts for - let's says - a few schemas and tables.
--
Francois PIETTE
http://www.overbyte.behttp://www.karaszi.com/SQLServer/info_generate_script.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Francois PIETTE" <fpiette@.newsgroups.nospam> wrote in message
news:uaBCyiJyHHA.1576@.TK2MSFTNGP03.phx.gbl...
> Using SQL Server Management Studio, it is easy to create scripts for various objects such as
> tables, schemas, login,... My question is: How can I automate the process ?
> I would like to write a kind of batch or script which when executed would generate the scripts
> for - let's says - a few schemas and tables.
> --
> Francois PIETTE
> http://www.overbyte.be
>|||Give ApexSQL's Script a try. It can script data as well as objects and
comes with a command line interface so you can automate it. Very reasonable
price too.
--
TheSQLGuru
President
Indicium Resources, Inc.
"Francois PIETTE" <fpiette@.newsgroups.nospam> wrote in message
news:uaBCyiJyHHA.1576@.TK2MSFTNGP03.phx.gbl...
> Using SQL Server Management Studio, it is easy to create scripts for
> various objects such as tables, schemas, login,... My question is: How can
> I automate the process ?
> I would like to write a kind of batch or script which when executed would
> generate the scripts for - let's says - a few schemas and tables.
> --
> Francois PIETTE
> http://www.overbyte.be
>|||> http://www.karaszi.com/SQLServer/info_generate_script.asp
Very interesting. I will investigate the various resources mentionned.
Thanks.
--
Francois PIETTE
http://www.overbyte.be
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> a écrit
dans le message de
news:542D05DE-A8A3-4877-9D2C-7E9392DEF9B7@.microsoft.com...
> http://www.karaszi.com/SQLServer/info_generate_script.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Francois PIETTE" <fpiette@.newsgroups.nospam> wrote in message
> news:uaBCyiJyHHA.1576@.TK2MSFTNGP03.phx.gbl...
>> Using SQL Server Management Studio, it is easy to create scripts for
>> various objects such as tables, schemas, login,... My question is: How
>> can I automate the process ?
>> I would like to write a kind of batch or script which when executed would
>> generate the scripts for - let's says - a few schemas and tables.
>> --
>> Francois PIETTE
>> http://www.overbyte.be
>|||>> http://www.karaszi.com/SQLServer/info_generate_script.asp
I tryed Microsoft SQL Server Database Publishing Wizard which is mentionned
on the page you referred. It does the job perfectly. It is free, has a GUI
interface and a command line utility. That's just what I needed.
http://www.microsoft.com/downloads/details.aspx?FamilyID=56e5b1c5-bf17-42e0-a410-371a838e570a&DisplayLang=en
Again, thanks.
--
Francois PIETTE
http://www.overbyte.be
"Francois PIETTE" <fpiette@.newsgroups.nospam> a écrit dans le message de
news:%23k$euHLyHHA.5584@.TK2MSFTNGP02.phx.gbl...
>> http://www.karaszi.com/SQLServer/info_generate_script.asp
> Very interesting. I will investigate the various resources mentionned.
> Thanks.
> --
> Francois PIETTE
> http://www.overbyte.be
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> a écrit
> dans le message de
> news:542D05DE-A8A3-4877-9D2C-7E9392DEF9B7@.microsoft.com...
>> http://www.karaszi.com/SQLServer/info_generate_script.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Francois PIETTE" <fpiette@.newsgroups.nospam> wrote in message
>> news:uaBCyiJyHHA.1576@.TK2MSFTNGP03.phx.gbl...
>> Using SQL Server Management Studio, it is easy to create scripts for
>> various objects such as tables, schemas, login,... My question is: How
>> can I automate the process ?
>> I would like to write a kind of batch or script which when executed
>> would generate the scripts for - let's says - a few schemas and tables.
>> --
>> Francois PIETTE
>> http://www.overbyte.be
>>
>|||Glad my page helped, and thanks for sharing you findings... :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Francois PIETTE" <fpiette@.newsgroups.nospam> wrote in message
news:eBg$qWLyHHA.600@.TK2MSFTNGP05.phx.gbl...
>> http://www.karaszi.com/SQLServer/info_generate_script.asp
> I tryed Microsoft SQL Server Database Publishing Wizard which is mentionned on the page you
> referred. It does the job perfectly. It is free, has a GUI interface and a command line utility.
> That's just what I needed.
> http://www.microsoft.com/downloads/details.aspx?FamilyID=56e5b1c5-bf17-42e0-a410-371a838e570a&DisplayLang=en
> Again, thanks.
> --
> Francois PIETTE
> http://www.overbyte.be
>
> "Francois PIETTE" <fpiette@.newsgroups.nospam> a écrit dans le message de
> news:%23k$euHLyHHA.5584@.TK2MSFTNGP02.phx.gbl...
>> http://www.karaszi.com/SQLServer/info_generate_script.asp
>> Very interesting. I will investigate the various resources mentionned.
>> Thanks.
>> --
>> Francois PIETTE
>> http://www.overbyte.be
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> a écrit dans le message de
>> news:542D05DE-A8A3-4877-9D2C-7E9392DEF9B7@.microsoft.com...
>> http://www.karaszi.com/SQLServer/info_generate_script.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Francois PIETTE" <fpiette@.newsgroups.nospam> wrote in message
>> news:uaBCyiJyHHA.1576@.TK2MSFTNGP03.phx.gbl...
>> Using SQL Server Management Studio, it is easy to create scripts for various objects such as
>> tables, schemas, login,... My question is: How can I automate the process ?
>> I would like to write a kind of batch or script which when executed would generate the scripts
>> for - let's says - a few schemas and tables.
>> --
>> Francois PIETTE
>> http://www.overbyte.be
>>
>