Anyone using Redgate SQL Source Control with RTC?

Walter Mansur (636●1●30●17) | asked Nov 22 '11, 10:53 a.m.

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

5 answers

Most liked answers ↑|Newest answers|Oldest answers

0	permanent link samifall fallatah (6●1●1) \| answered Jan 29 '12, 9:00 a.m. Hi there, Were Are using RTC 3.0.1 and we are trying to connect RedGate to it. did you had any luck integrating them? Thank,

permanent link

Walter Mansur (636●1●30●17) | answered Jan 30 '12, 11:39 a.m.

Hello,

No, we have not been able to accomplish the integration of RTC and Redgate SQL Source Control. It has become a low priority issue for us at this time.

-Walter

Hi there,
Were Are using RTC 3.0.1 and we are trying to connect RedGate to it.

did you had any luck integrating them?

Thank,

0	permanent link Martina Riedel (203●2●32●41) \| answered Mar 19 '12, 3:28 p.m. Hi there, Were Are using RTC 3.0.1 and we are trying to connect RedGate to it. did you had any luck integrating them? Thank, Have you made any progress? This has come up for us as well.

permanent link

Ahmed Abuabdou (11) | answered Apr 10 '12, 1:34 p.m.

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\):

&lt;xml&gt;

&lt;!----&gt;



&lt;!--

-Creating a custom config file-

To create a config file for your source control system&#58;



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&#58;

   %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-

&lt;CommandLine&gt; is a command run using cmd.exe. You can specify the following macros in a command&#58;

&#40;$Files&#41; - Any files that the command should be executed for

&#40;$Folders&#41; - Any folders that the command should be executed for &#40;optional&#41;

&#40;$ScriptsFolder&#41; - The working folder that has been linked to 

&#40;$Message&#41; - The message that is added on committing to source control

&#40;$MessageFile&#41; - A txt file containing the message that is added on committing to source control



&lt;Verify&gt; is a C# expression used to check the command line executed successfully. Verify has the following variables&#58;

exitCode - The error level/exit code returned by the command

output - The console output from the command

--&gt;



&lt;HooksConfig&gt;

  &lt;The&gt;

  &lt;Name&gt;Template&lt;/Name&gt;

  &lt;Commands&gt;

    &lt;element&gt;

      &lt;key&gt;GetLatest&lt;/key&gt;

      &lt;Updates&gt;

      &lt;Valid&gt;

      &lt;value&gt;

        &lt;CommandLine&gt;&lt;/CommandLine&gt;

        &lt;Verify&gt;exitCode == 0&lt;/Verify&gt;

      &lt;/value&gt;

    &lt;/element&gt;

    &lt;element&gt;

      &lt;key&gt;Add&lt;/key&gt;

      &lt;Adds&gt;

      &lt;Valid&gt;

      &lt;value&gt;

        &lt;CommandLine&gt;&lt;/CommandLine&gt;

        &lt;Verify&gt;exitCode == 0&lt;/Verify&gt;

      &lt;/value&gt;

    &lt;/element&gt;

    &lt;element&gt;

      &lt;key&gt;Edit&lt;/key&gt;

      &lt;Makes&gt;

      &lt;Valid&gt;

      &lt;value&gt;

        &lt;CommandLine&gt;&lt;/CommandLine&gt;

        &lt;Verify&gt;exitCode == 0&lt;/Verify&gt;

      &lt;/value&gt;

    &lt;/element&gt;

    &lt;element&gt;

      &lt;key&gt;Delete&lt;/key&gt;

      &lt;Deletes&gt;

      &lt;Valid&gt;

      &lt;value&gt;

        &lt;CommandLine&gt;&lt;/CommandLine&gt;

        &lt;Verify&gt;exitCode == 0&lt;/Verify&gt;

      &lt;/value&gt;

    &lt;/element&gt;

    &lt;element&gt;

      &lt;key&gt;Commit&lt;/key&gt;

      &lt;Commits&gt;

      &lt;Valid&gt;

      &lt;value&gt;

        &lt;CommandLine&gt;&lt;/CommandLine&gt;

        &lt;Verify&gt;exitCode == 0&lt;/Verify&gt;

      &lt;/value&gt;

    &lt;/element&gt;

    &lt;element&gt;

      &lt;key&gt;Revert&lt;/key&gt;

      &lt;Undoes&gt;

      &lt;Valid&gt;

      &lt;value&gt;

        &lt;CommandLine&gt;&lt;/CommandLine&gt;

        &lt;Verify&gt;exitCode == 0&lt;/Verify&gt;

      &lt;/value&gt;

    &lt;/element&gt;

  &lt;/Commands&gt;

&lt;/HooksConfig&gt;

For instance, A sample working configuration for Mercurial looks as follows:

&lt;xml&gt;

&lt;!----&gt;



&lt;This&gt;



&lt;HooksConfig&gt;

  &lt;Name&gt;Mercurial&lt;/Name&gt;

  &lt;Commands&gt;

    &lt;element&gt;

      &lt;key&gt;GetLatest&lt;/key&gt;

      &lt;value&gt;

        &lt;CommandLine&gt;hg update&lt;/CommandLine&gt;

        &lt;Verify&gt;exitCode == 0&lt;/Verify&gt;

      &lt;/value&gt;

    &lt;/element&gt;

    &lt;element&gt;

      &lt;key&gt;Add&lt;/key&gt;

      &lt;value&gt;

        &lt;CommandLine&gt;hg add &#40;$files&#41;&lt;/CommandLine&gt;

        &lt;Verify&gt;exitCode == 0&lt;/Verify&gt;

      &lt;/value&gt;

    &lt;/element&gt;

    &lt;element&gt;

      &lt;key&gt;Edit&lt;/key&gt;

      &lt;value&gt;

        &lt;CommandLine&gt;&lt;/CommandLine&gt;

        &lt;Verify&gt;&lt;/Verify&gt;

      &lt;/value&gt;

    &lt;/element&gt;

    &lt;element&gt;

      &lt;key&gt;Delete&lt;/key&gt;

      &lt;value&gt;

        &lt;CommandLine&gt;hg remove &#40;$files&#41;&lt;/CommandLine&gt;

        &lt;Verify&gt;exitCode == 0&lt;/Verify&gt;

      &lt;/value&gt;

    &lt;/element&gt;

    &lt;element&gt;

      &lt;key&gt;Commit&lt;/key&gt;

      &lt;value&gt;

        &lt;CommandLine&gt;hg commit -I &quot;&#40;$ScriptsFolder&#41;*&quot; -l &quot;&#40;$MessageFile&#41;&quot;&lt;/CommandLine&gt;

        &lt;Verify&gt;exitCode == 0&lt;/Verify&gt;

      &lt;/value&gt;

    &lt;/element&gt;

    &lt;element&gt;

      &lt;key&gt;Revert&lt;/key&gt;

      &lt;value&gt;

        &lt;CommandLine&gt;hg revert -I &quot;&#40;$ScriptsFolder&#41;*&quot; *&lt;/CommandLine&gt;

        &lt;Verify&gt;exitCode == 0&lt;/Verify&gt;

      &lt;/value&gt;

    &lt;/element&gt;

  &lt;/Commands&gt;

&lt;/HooksConfig&gt;

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

permanent link

Ahmed Abuabdou (11) | answered Apr 24 '12, 2:24 a.m.

Dear Walter,

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

It's all about the answers!

Related questions

Anyone using Redgate SQL Source Control with RTC?

5 answers

Your answer