For configuration management I would like to generate a script of the entire database on a nightly basis....I can then import that sql file into source control and have a history of the db.
The functionality I am looking for is the same as when you right click on any object and choose 'Generate SQL Script'...then I choose all the options I want.
Is there a DTS or command line version of this I can use to automate this?