Recover previous version of Stored Proc from SQL Source Cont

WadeN

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.

David Atkinson

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.