About Version Control

Toad integrates with your existing version control system so you can maintain multiple revisions of objects and SQL scripts . See Configure Version Control for more information on configuring version control in Toad.

Important: See Troubleshoot Version Control for more information about issues when upgrading version control from a previous version.

Notes:

Version Control can be configured for MS SQL Server 2005 and above.
If you want to place database objects under version control, you must configure version control for objects using the Object Explorer. Once configured, you can manage SQL scripts there. The main advantage of managing scripts in the Object Explorer is that you can easily share them with team members who have version control configured. See Manage Objects under Version Control for more information.
If you rename a version controlled object, Toad drops the original object and its history from version control and prompts you to add the renamed object to version control. This newly renamed object does not have any history associated with it.
Currently, CLR objects are not supported by version control.

Prerequisites

You must install a supported version control client on the computer where Toad is installed. The following table lists the supported version control providers and the versions tested with Toad.

Supported Provider	Server Version Tested	Client Version Tested
Apache Subversion™	Subversion 1.7.5 on Windows	CollabNet Subversion Command-Line Client 1.7.5 Note: Any Subversion client must have svn.exe in its installation directory to use version control in Toad.
Team Foundation Server (TFS)	TFS 2008, 2010, 2012	Visual Studio^® (2008, 2010, 2012) Team Explorer Client
File system based	Toad allows to utilize practically any version control system using the external client tool. In this case Toad Version Control tool works with the directories at local HDD while you commit changes to the repository with version control client tool.
Note: Toad connects to your version control system based on login information included in the configuration. Your version control client does not need to run for Toad to connect.

The following objects can be added to Version Control:

TABLE

VIEW

STORED PROCEDURE

FUNCTION

SEQUENCE

UDDT

RULE

DEFAULT

SQL SCRIPT