Get deployment script

duliduli Posts: 2 New member
in SQL Source Control
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!
Tagged:
· Share on Twitter

Answers

  • David AtkinsonDavid Atkinson Posts: 1,458 Rose Gold 2
    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.


    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.