Get deployment script

duli

I've got several changes that I'm checking into Git, and I know that this generates a bunch of scripts for indexes etc that have been changed. How can I get access to this script? What I want to get is a sql script with all the add/drop indexes, alter columns etc that were checked in. 

Thanks!

David Atkinson

You need SQL Compare Pro (which you will have if you own the SQL Toolbelt). You can load in the scripts folder from version control as the source, and set the target to be any downstream database, such as QA, Staging or Production. After the comparison use the Deployment Wizard to generate the script.