Deployment Scripts

We are introducing a new infrastructure in work where we use depoyment
scripts rather than tweaking the db with Enterprise Manager. While I can see
the benefits of this it will be time consuming. Are there any tools out
there to automatically generate any kind of DDL script you would want. For
instance I can't find a way in Enterprise Manager/ Query Analyser to
generate logins or stuff related to jobs. Regards, Chris.Chris,
to generate logins, there is the Options tab on the Generate SQL Scripts
dialogue. For jobs, just highlight them all and right-click.
There are other things that aren't scriptable though from the GUI (linked
servers, maintenance plans, diagrams etc). For these I know of workarounds
but no simple tool. BTW in SQL Server 2005 almost anything is scriptable
from the GUI.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Chris wrote:
> We are introducing a new infrastructure in work where we use depoyment
> scripts rather than tweaking the db with Enterprise Manager. While I can see
> the benefits of this it will be time consuming. Are there any tools out
> there to automatically generate any kind of DDL script you would want. For
> instance I can't find a way in Enterprise Manager/ Query Analyser to
> generate logins or stuff related to jobs. Regards, Chris.
>
Kudos to whoever is driving this change. It may seem time consuming
now, but after you get used to it, you'll find that the GUI is actually
harder to use than writing the scripts.
While some things may not be directly scriptable from Enterprise
Manager, virtually EVERYTHING that EM does can be done using scripts,
you just have to learn the commands. One way to observe what goes on
under the covers is to use Profiler to capture the commands issued by EM
when performing various operations.
Tracy McKibben
MCDBA
http://www.realsqlguy.com