You can update your local database to a specific revision with the help of Schema Compare and Sync functionality of dbForge Studio.
1. Run the Schema Comparison wizard.
2. On the Source and Target page, select Source Control as Source and a local database - as Target.
3. From the Revision dropdown list, select the Select a specified revision option to select a specific revision. The Revision History dialog opens.
4. Select the required revision and then click Select.
5. Run schema comparison, analyze comparison results, and synchronize revision with the database schema. For more information about schema comparison and synchronization, refer to the Comparing and Synchronizing Database Schemas section of the product documentation.
Download dbForge Studio for SQL Server and try it absolutely free for 30 days!