How to integrate SCM Anywhere Hosted with Red Gate’s SSMS?

Please follow the steps below to integrate SCM Anywhere Hosted with Red Gate's SSMS:
(Note: The process is based on SCM Anywhere Hosted 2.3. If you are using an old version, please upgrade to the latest version first.)

1. Back up SCMHCMD.exe located at the installation folder of SCM Anywhere Hosted.

2. Download SCMHCMD.exe and put the file to the installation folder of SCM Anywhere Hosted.

3.Download SCMH.xml and unzip the file to "C:\Documents and Settings\{username}\Local Settings\Application Data\Red Gate\SQL Source Control 2\CommandLineHooks".

4.Modify SCMH.xml accordingly.

<CommandLine>"C:\Program Files\Dynamsoft\SCM Anywhere Hosted Client\scmhcmd.exe" OrganizationIDUserName pwd teamproject $/ get "($Message)" "" "($ScriptsFolder)" </CommandLine>

The above lines are copied from SCMH.xml. "C:\Program Files\Dynamsoft\SCM Anywhere Hosted Client\scmhcmd.exe" is the path of SCMHCMD.exe.

5.Open Microsoft SQL Server Management Studio. Right-click on the database you want to add to the source control. Choose "Link database to source control".


6. In the Link to Source Control dialog box, choose More. Specify the location of the working folder, and select SCMH as the current source control system. Click Link to link the database to SCM Anywhere.

Now, you can right-click on the files in the database to add files/modifications to source control.

Is this page helpful?

Leave a Reply

Your email address will not be published.