SQL Source Control - 1.1
Learning SQL Source Control - 1.1
Viewing source control logs / history
You can use SQL Source Control to view the log or history information for a database or database object from within SQL Server Management Studio.
To view the logs / history, in SQL Server Management Studio, in the Object Explorer, right-click the database or object and click Show History:
The History dialog box is displayed:
The History dialog box shows:
- Each version; this is the 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
You can use the History dialog box to get a specific version of the database
See also |
Was this article helpful?
Search support
Forums
Visit the SQL Source Control forum.
Getting started
Worked example: setting up SQL Source Control with SVN for development teams
Worked example: setting up SQL Source Control with TFS for development teams
Using SQL Source Control
Linking a database to source control
Committing changes
Getting the latest version
Using SVN bug IDs & TFS work items
Viewing source control logs / history
Getting a specific version
Undoing changes
Conflicts
Deploying a database from source control
Setting up a local Subversion repository
Setting up a Subversion server
Continuous integration
Source controlling data
Evaluation center
Worked example: setting up SQL Source Control with SVN for development teams
Worked example: setting up SQL Source Control with TFS for development teams
Using SQL Source ControlLinking a database to source controlCommitting changesGetting the latest versionUsing SVN bug IDs & TFS work itemsViewing source control logs / historyGetting a specific versionUndoing changesConflictsDeploying a database from source controlSetting up a local Subversion repository
Setting up a Subversion server
Continuous integration
Source controlling data
Evaluation center
SQL Source Control
- Setting SQL Compare options within SQL Source Control
- "ICredentialsProvider is unset, therefore can't get" error occurring within SQL Source Control
- Linking fails due to SVN pre-commit hooks
- Logging changes to shared databases
- Object changed by Unknown
- Setting permissions for SQL Source Control
- Using SQL Source Control with Team Foundation Server 2012 or tfspreview.com
- Error: Failed to resolve no-ops after 5 tries
- Using SQL Compare or SQL Changeset scripts with SQL Source Control
all SQL products
- Compatibility of Red Gate tools in 64-bit environments
- Application has encountered an error and needs to close
- Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found.
- Changing the temporary directory used by the installer
- Toolbelt Installer "hanging" while "scanning volumes"
- Login failing with "trusted SQL Server connection" error when using RunAs
all products
- Some Red Gate products identified as containing a trojan by Anti-Virus software
- Activation may fail with Unknown Error -1
- Product uses web help although a CHM file is available locally
- Argument exception resulting from missing environment variable
- Check for updates may fail when used through proxies
- 'Unidentified Publisher' error when repairing or uninstalling
- Licensing activates product as standard edition
- Moving Red Gate software products to another machine
- Red Gate tools log locations
- The application UI opening slowly when there is no internet access
SQL Source Control
- Database development models
- Release notes - version 1.0
- Release notes - version 1.1
- Release notes - version 2.0
- Release notes - version 2.1
- Release notes - version 2.2
- Requirements & prerequisites
- Technical Overview
- Release notes - version 3.0
all SQL products
all products
- Red Gate product acknowledgements
- Activating your products
- Activating your products
- Red Gate bundle history
- Check for updates
- Troubleshooting Check for Updates errors
- Current versions
- Deactivating your products
- Installing Red Gate products from the .msi file
- Requesting additional activations
- Serial numbers for bundles
- Reactivating using a different serial number
- Extending your trial
- Finding your serial numbers
- Moving a serial number from one computer to another
- No response received for manual activation
- Licensing and activation resources
- Licensing and activation resources
- Troubleshooting licensing and activation errors
- Licensing and activation FAQs
- Red Gate tools log file locations
- Download old versions of products
- Download product prerequisites & utilities
- Support & upgrades
- Upgrading your software
- Upgrading FAQs
