Welcome to the Jazz Community Forum
Anyone using Redgate SQL Source Control with RTC?

We are on RTC v2.0.0.2, iFix6 on Windows.
We are trying to get Redgate SQL Source Control to work with RTC. This is a tool that can be used to put databases under source control. It works with several source control systems - Team Foundation Server, Perforce, Git, SVN, and several others. It does the "integration" via the "command line". Which leads me to believe that it could work with RTC.
SQL Source Control uses "config" files to make the integrations work. I can actually setup a "config" file for RTC and it almost works. However, trying to run the RTC/SQL Source Control integration results in a "lock" condition. I did work with the support people at Redgate on this and they ran into the same issue. They downloaded and installed RTC Express on one of their servers for their testing.
I would be interested to hear if anyone is using Redgate SQL Source Control with RTC.
Thanks,
-Walter
We are trying to get Redgate SQL Source Control to work with RTC. This is a tool that can be used to put databases under source control. It works with several source control systems - Team Foundation Server, Perforce, Git, SVN, and several others. It does the "integration" via the "command line". Which leads me to believe that it could work with RTC.
SQL Source Control uses "config" files to make the integrations work. I can actually setup a "config" file for RTC and it almost works. However, trying to run the RTC/SQL Source Control integration results in a "lock" condition. I did work with the support people at Redgate on this and they ran into the same issue. They downloaded and installed RTC Express on one of their servers for their testing.
I would be interested to hear if anyone is using Redgate SQL Source Control with RTC.
Thanks,
-Walter
5 answers

Hi there,
Have you managed to successfully integrate them?
I am having the same issue.
RedGate provides a template file to be filled with the command line options; a sample template would look like this (located in %AppData%\Local\Red Gate\SQL Source Control 3\CommandLineHooks\):
For instance, A sample working configuration for Mercurial looks as follows:
I have been trying to figure out the scm commands to write and I am still exploring around it.
Regards
Have you managed to successfully integrate them?
I am having the same issue.
RedGate provides a template file to be filled with the command line options; a sample template would look like this (located in %AppData%\Local\Red Gate\SQL Source Control 3\CommandLineHooks\):
<xml>
<!---->
<!--
-Creating a custom config file-
To create a config file for your source control system:
1. Specify commands and verification codes below for the source control actions you want to automate.
2. Save your changes as a new XML file in the default config files folder:
%USERPROFILE%\AppData\Local\Red Gate\SQL Source Control 2\CommandLineHooks
Do not store any usernames, passwords, or other sensitive data in this config file. The contents of the config file
will be checked into your source control repository and may, with your consent, be sent to Red Gate if SQL Source Control
crashes.
-Tags-
<CommandLine> is a command run using cmd.exe. You can specify the following macros in a command:
($Files) - Any files that the command should be executed for
($Folders) - Any folders that the command should be executed for (optional)
($ScriptsFolder) - The working folder that has been linked to
($Message) - The message that is added on committing to source control
($MessageFile) - A txt file containing the message that is added on committing to source control
<Verify> is a C# expression used to check the command line executed successfully. Verify has the following variables:
exitCode - The error level/exit code returned by the command
output - The console output from the command
-->
<HooksConfig>
<The>
<Name>Template</Name>
<Commands>
<element>
<key>GetLatest</key>
<Updates>
<Valid>
<value>
<CommandLine></CommandLine>
<Verify>exitCode == 0</Verify>
</value>
</element>
<element>
<key>Add</key>
<Adds>
<Valid>
<value>
<CommandLine></CommandLine>
<Verify>exitCode == 0</Verify>
</value>
</element>
<element>
<key>Edit</key>
<Makes>
<Valid>
<value>
<CommandLine></CommandLine>
<Verify>exitCode == 0</Verify>
</value>
</element>
<element>
<key>Delete</key>
<Deletes>
<Valid>
<value>
<CommandLine></CommandLine>
<Verify>exitCode == 0</Verify>
</value>
</element>
<element>
<key>Commit</key>
<Commits>
<Valid>
<value>
<CommandLine></CommandLine>
<Verify>exitCode == 0</Verify>
</value>
</element>
<element>
<key>Revert</key>
<Undoes>
<Valid>
<value>
<CommandLine></CommandLine>
<Verify>exitCode == 0</Verify>
</value>
</element>
</Commands>
</HooksConfig>
For instance, A sample working configuration for Mercurial looks as follows:
<xml>
<!---->
<This>
<HooksConfig>
<Name>Mercurial</Name>
<Commands>
<element>
<key>GetLatest</key>
<value>
<CommandLine>hg update</CommandLine>
<Verify>exitCode == 0</Verify>
</value>
</element>
<element>
<key>Add</key>
<value>
<CommandLine>hg add ($files)</CommandLine>
<Verify>exitCode == 0</Verify>
</value>
</element>
<element>
<key>Edit</key>
<value>
<CommandLine></CommandLine>
<Verify></Verify>
</value>
</element>
<element>
<key>Delete</key>
<value>
<CommandLine>hg remove ($files)</CommandLine>
<Verify>exitCode == 0</Verify>
</value>
</element>
<element>
<key>Commit</key>
<value>
<CommandLine>hg commit -I "($ScriptsFolder)*" -l "($MessageFile)"</CommandLine>
<Verify>exitCode == 0</Verify>
</value>
</element>
<element>
<key>Revert</key>
<value>
<CommandLine>hg revert -I "($ScriptsFolder)*" *</CommandLine>
<Verify>exitCode == 0</Verify>
</value>
</element>
</Commands>
</HooksConfig>
I have been trying to figure out the scm commands to write and I am still exploring around it.
Regards
We are on RTC v2.0.0.2, iFix6 on Windows.
We are trying to get Redgate SQL Source Control to work with RTC. This is a tool that can be used to put databases under source control. It works with several source control systems - Team Foundation Server, Perforce, Git, SVN, and several others. It does the "integration" via the "command line". Which leads me to believe that it could work with RTC.
SQL Source Control uses "config" files to make the integrations work. I can actually setup a "config" file for RTC and it almost works. However, trying to run the RTC/SQL Source Control integration results in a "lock" condition. I did work with the support people at Redgate on this and they ran into the same issue. They downloaded and installed RTC Express on one of their servers for their testing.
I would be interested to hear if anyone is using Redgate SQL Source Control with RTC.
Thanks,
-Walter

Dear Walter,
Could you post the config file have created for Jazz RTC?\
Thanks
Could you post the config file have created for Jazz RTC?\
Thanks
We are on RTC v2.0.0.2, iFix6 on Windows.
We are trying to get Redgate SQL Source Control to work with RTC. This is a tool that can be used to put databases under source control. It works with several source control systems - Team Foundation Server, Perforce, Git, SVN, and several others. It does the "integration" via the "command line". Which leads me to believe that it could work with RTC.
SQL Source Control uses "config" files to make the integrations work. I can actually setup a "config" file for RTC and it almost works. However, trying to run the RTC/SQL Source Control integration results in a "lock" condition. I did work with the support people at Redgate on this and they ran into the same issue. They downloaded and installed RTC Express on one of their servers for their testing.
I would be interested to hear if anyone is using Redgate SQL Source Control with RTC.
Thanks,
-Walter