This tool is designed to create individual script files and directories of schema changes to make source control with Subversion easier. The current release just generates the files. The next release will include a subversion tool to take care of the whole process at once. This is a console application to make scripting easier.
SVNForSQL2005.exe -? -s[erver]:ServerName -db:DatabaseName -u:UserLogin -pwd:password
-procedures -tables -fti -functions -views
-? shows this message
-s[erver] Fully qualified name of the database server
-db Database name
-u User login -pwd Password (do not include to use trusted connection)
-procedures Flag to include stored procedures
-tables Flag to include tables
-fti Flag to include Full Text Indexing information
-functions Flag to include User Defined Functions
-views Flag to include Views
-uddts Flag to include User Defined Data Types
This will generate individual scripts for objects. It only generates the script if the generated script differs from the file that exists. It also removes files that do not exist in the database. It creates a file dbo.genericsproc.sql in the procedure directory because that stored procedure exists. If that sproc is dropped then the next time the program is run it will discover that the file refers to a stored procedure that no longer exists and will delete the file.
Download this file from the Software Repository.