Viewing source control history
Published 25 March 2013
You can only view history for databases linked to SVN, TFS or Vault. To view history for other source control systems, use your source control client's history feature.
You can use SQL Source Control to view the revision history of a database or database object.
In the Object Explorer, right-click the database or object and click View history:
The History dialog box opens:
The History dialog box shows:
- each database revision in source control (SVN revision or TFS changeset)
- the author, date, and comment associated with each commit
- which objects changed in each commit
- the SQL differences for each object (before and after)
You can use the History dialog box to get a specific version of the database.
Changing the number of revisions shown
In SQL Source Control 3.5.1 and later, you can change the number of revisions shown in the History dialog box by editing a config file. If the History dialog box is slow to load, limiting the number of revisions shown might speed it up. For more information, see Changing the number of revisions shown in the History dialog box.
