Update to a revision from source control

Schema Compare allows you to update a database to a particular revision from source control.

Note

If you update your database to a particular revision, the current database schema will be overwritten by the changes introduced with the selected version.

Update to a specific version with Schema Compare

To update your database schema to a particular version:

1. On the File menu, click New Schema Comparison.

2. In the New Schema Comparison wizard, specify Source and Target connections.

Source and Target For Comparison

3. Under Source, specify Source Control as Type and indicate the name of your Repository.

See also: How to configure a link to your repository.

4. Specify the Revision you want to update the database to. Note that the Latest (Head) Revision is specified by default.

5. To specify a different revision, choose <…Select a specified revision…> from the drop-down list. In the Revision history window that opens, you can see the list of the source-control revisions of your database.

Revision History Window

6. Select a required revision, and you will see the code changes introduced by the commit in the Window below. You can also read a commit message and identify the operation that has taken place in this particular revision.

7. Configure the rest of the settings and start the comparison process.

Comparing a Source Control Version Against a Database

8. Click Compare Button to synchronize the objects to the target database. Configure and run the synchronization.

9. The database is updated to the revision you selected.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Schema Compare for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Schema Compare in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Schema Compare for your business, request a demo to see it in action.
Ready to start using dbForge Schema Compare for SQL Server?