Automating the generation of a SQL Script | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Automating the generation of a SQL Script

In SQL 2000, it is possible to generate a script in code by using scptxfr.exe. More details here:
http://www.databasejournal.com/features/mssql/article.php/10894_3401081_2 I have read on the web that this functionality is not included in SQL 2005. I need help with the following: * Can anyone confirm or deny this? * Can anyone suggest how I can automate the process of generating a script for all objects in a database in SQL 2005?
Yes it is not available in SQL 2005 so far, you can use Generate SQL Server Scripts Wizard in order to accomplish this task or you can use DMOhttp://www.mindsdoor.net/DMO/DMOScriptAllDatabases.html as referred here. 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.
Thank you for this
We may not know until 2005 RTM whether it is entirely replaced in SQL 2005 or else any other feature will be taking care of this task. 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.
]]>