Go to the SQLScripter download page
SQLScripter is a powerful command line utility that scripts SQL Server objects. The utility is designed to automate the process of schema generation.
SQLScripter scripts your entire server. Schedule an automatic job that scripts all database level objects and server level objects on a daily or weekly basis.
Script Jobs, Logins, Linked Servers, Tables, Views, Stored Procedures, Users, UDFs, Indexes....
Oooops... a problem found in a stored procedure loaded in the recent version - no need to look for the appropriate backup and restore. Save that time and immediately get the required object available on your file system.
Your developers access the production servers to see if the schema matches the schema at their environment - not any more, automate a job that brings the production schema to your organization and save your developers and your organization a lot of precious time.
Besides the ability to script all objects there are many command line switches that are helpful in the DBA”s routine tasks, for example while tuning your indexes the I switch will generate 3 files: one file contains the CREATE statements for all indexes, one file contains the CREATE statements for all indexes excluding PKs and one file contains the DROP statements. Similarly the switch FK will generate 2 files: one file contains the CREATE statements and one file containing the DROP statements for all Foreign Key Constraints. This can be done for a single database, a few databases or all databases on the server. In the same way the switch TR will script triggers. DBAs working with Replication may find the NFR switch useful. For the complete list of available switches see the ReadMe file.
SQLScripter can be useful in some High Availability scenarios where you need to assure that objects belonging to a specific server are always available and exists on another server when a disaster event occurs.
SQLScripter is a professional tool at a low cost price.
Installation and configuration is quick. The product is very light and when you install it you do not effect anything on your machine.
For additional details see the SQLScripter ReadMe file
Go to the SQLScripter download page