Version Control for files you have created using Toad Data Point

Recently I have had several people ask me how they can use version control in Toad Data Point. At first I found this question a little confusing since I have always equated version control with application development teams tracking changes to their source code and dba’s tracking the changes they have been making in their databases.

Well, I am learning that as more and more analysts start using tools to create queries to gather data that they too want to be able to track their changes overtime.

Toad Data Point to the rescue!

Toad Data Point works with the Subversion vcs. Once you have the credentials for your subversion environment you can simply setup Toad Data Point to point to it and as you save your files you will be prompted to commit them to subversion.

Setup is found under the Tools -> Options menu item.

There are 2 options for Version Control. As shown above, the first one, General, is where you can choose to have Toad Data Point automatically commit your file to the vcs when you save it.

As shown below, the Configurations option is where you configure your vcs parameters.

Make sure you ‘enable’ the configuration that you are working with.

Then you provide the details about your Subversion environment by clicking on the ‘Properties…” button.

We are looking for the Binary Path information here.

Then you enter the Server information, the username and password and finally you enter the Version Control Folder and working folder that you are using to store your files.

When done, click on the OK button.

Now you can start working in Toad Data Point and saving your queries.

Here you can see that I have a query in the editor:

The vcs information is found by right-clicking on the TAB for the editor window.

Since this is a new file that I am working on I am given the option to “Add file to working folder”. This will open an explorer window that points to the Version Control Folder we configured earlier.

Just give it a name and click on SAVE (which you don’t see in this window).

You are then prompted to Commit your change to the vcs. Feel free to add comments as appropriate then click on OK.

Congratulations! You have just saved the file you are working on into your Subversion vcs. Now when you do a right-click on the editor window tab you will see different options for the file you just saved.  You can browse the repository, show the history of this file, update the status of the file and view the files by using the Windows Explorer.

==============================================================================

As you keep working with this file and making changes you can save the file and have your changes added to your Subversion vcs and now you have a history of your work.

 

Have fun and happy query writing!

About the Author
  • Mark, thanks for the information. A few questions:

    1. In options when I go to Configurations under Version Control, everything is greyed out and it says "You must configure version control before you can modify configuration options.... in the object explorer right-click the database and select version control > version control wizard"

    I'm not seeing the above option if I right click on a database in the object explorer window?

    2. I'm trying to see if Toad Data Point 4.2 supports GIT or only SVN. Do you know?