How to automate script generation? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to automate script generation?

I use Enterprise Manager interactively to generate SQL scripts to create tables, views, SP, user functions and constraints. I would like to automate the process so that it can be run unattended everyday. Is there any tool or utility for such a task? An entire DB back up is done daily. However, the team lead would like to have the scripts to better manage the code change. Thanks in advance for any help.
you can use SQL-DMO to do this, but some programming effort is required. Tom Pullen
DBA, Oxfam GB
Check my webloghttp://www.sql-server-performance.com/absolutenm/templates/?a=9&z=1 about scripting. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Wonderful references, exactly what I was looking for. Thanks you very much for your help.
]]>