I am presenting at the December meeting of PSSUG. December The topic is "Metadata Driven Database Deployments." I have a mechanism I have been using for about 13 years where we can deploy a new database or upgrade an existing database in a fast, reliable, repeatable manner. And the best part is, you don't need to know esoteric DDL commands. Certainly you can use things like "scripting wizards" and "SQL compare" tools to do this but I'll show you some benefits that having a custom DDL deployer can handle that other tools cannot.
Feel free to come out and learn about my deployment techniques. Or just come out to heckle me.
sql server md3