Configuring Subversion integration with Toad for SQL Server, DB2, and SAP Databases

I've been seeing more customers ask about integrating Toad with their version control systems. Toad for Oracle users have enjoying that for a long time, but now other Toad products are picking up support as well.

Subversion is an easy way to get started with version control. In this step by step tutorial, I'll show you how to integrate the Toad .NET products (Toad for SQL Server, Toad for DB2, and Toad for SAP Databases) with Subversion.

Download and install VisualSVN Server on to a "server" machine. Doesn't have to be a real server, just a machine that you and your colleagues can reach through your network. I find VisualSVN to be one of the easiest to install and configure. 

Once installed, launch VisualSVN Server from the desktop or start menu. Right click on Repositories and select “Create New Repository.”

In the wizard, select regular FSFS repository and click next. Give the repository a name that represents your application then click next. I'm using “SAP_DEMO” for this example. Select “Create an Empty Repository.” Then select all Subversion users have read/write and click finish. A new repository is created and you can see the URL in the upper right.

Right click on the repository and select New, then Folder. Created a folder to store your code. Mine is called “project1”

Create a user if you haven’t before. Right click on the User folder, create new user, and give it a username and password. I used dev1.

You’re done with this server machine, now switch to a client PC or wherever you have Toad installed.

You will need to download and install a Subversion client if you haven’t already. As long as it has the file SVN.exe, you can use any client, like VisualSVN or TortoiseSVN. Find where the file SVN.exe is located after you install it. With VisualSVN as a client install, it is in the default folder C:\Program Files (x86)\VisualSVN\Bin.

Connect to a database using Toad. Right click on a table and select “Version Control Wizard.” My screenshots are using Toad for SAP Solutions.

The wizard will prompt you for granularity. Different Toad’s will have different abilities here. I'm just going to use the default option here.

Click on the properties and then enter the path to your Subversion client (SVN.exe).

Put in the URL for the Subversion server, then the username and password.

For Version Control Folder, select the folder you created on the server. In my case it’s called “project1.” Then select any folder on your local computer. I created a new folder called sap_demo on my C: and select that folder to be initialized, which created the project1 folder and additional folders inside of project1.

Version Control is now set up. Commit an item to Version Control through right click:

Item will be added to Subversion:

You can right click on it again to update the object:

Go back to your server and you can see the item is inside SVN:

Now you can manage your Subversion repository from inside your favorite Toad products instead of having to switch back and forward with the Subversion client.

About the Author
Mathew is a Systems Consultant with Quest Software based out of Southern California and specializes in the Toad database management tools. He has spent 11 years working with Toad, starting as a Technical...