Generating SQL scripts | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Generating SQL scripts

Greetings from newby… I’m trying to have a script scripts that will help dump the schema from one of our "Site-Server", currently were doing it manually by selecting each one of our DB’s, right click and selecting "All tasks->Generate SQL Scripts". It can easily understood how much time is waisted and how problematic can be this process (if the one dumping the schema forgets to add one chek box in the wizard..). Since we have an amount of "Site-Server’s", I would prefer not using any SP or any other method which will force me to make any changes in the server. Any ideas. Thanks As In Advanced – For any idea, pointing etc. .. for information on automating the task. HTH Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.