Recover previous version of Stored Proc from SQL Source Cont

WadeNWadeN Posts: 2
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.

Comments

  • 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
Sign In or Register to comment.