Recover previous version of Stored Proc from SQL Source Cont

WadeNWadeN Posts: 2
edited May 10, 2015 12:11PM in SQL Source Control Previous Versions
Is there a way to see or recover previous versions of stored procedures or tables structures that were committed to SQL Source Control. I see how to get the latest version, but suppose I want to get or see a version that was committed 4 versions ago - is there a way to do this? Thanks.
· Share on Twitter

Comments

  • David AtkinsonDavid Atkinson Posts: 1,460 Rose Gold 2
    In SSMS, right click on the database (or on the Stored Procedures node) and select View History. You should be able to find the historical versions of your objects here. Copy and paste the create statement for your procedure into SSMS and execute it.

    Alternatively, if you want to do this using SQL Compare, you can set a historical source control version as the source database (select the Source Control radio button). Running a comparison and the Deployment Wizard will allow you to recover your objects.
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.