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/in...rate_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 vario
us 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/in...rate_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/in...rate_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...
>|||>> http://www.karaszi.com/SQLServer/in...rate_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/...&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...
> 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...
>|||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...
> I tryed Microsoft SQL Server Database Publishing Wizard which is mentionne
d 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/...&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...
>

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.be
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
>
|||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...
>
|||>> 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...
> 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...
>
|||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...
> 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...
>