Knowledge Base

The leading provider of version control solutions and TWAIN SDKs

How to integrate SourceAnywhere 4.x with Red Gate's SSMS?

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

1. Install SourceAnywhere COM SDK. You can download it here.

2. Back up SAWSCmd.exe located at the installation folder of SourceAnywhere.

3. Download the ZIP file that contains a new "SAWSCmd.exe" file and "Interop.SAWSSDKLib.dll" file from link below. Then, put them to the installation folder of SourceAnywhere.

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

5. Modify SAWS.xml accordingly.

<CommandLine>"C:\Program Files (x86)\Dynamsoft\SourceAnywhere Client\SAWSCMD.exe" Server Port UserName pwd teamproject $/ get "($Message)" "" "($ScriptsFolder)" </CommandLine>

After modify, the parameters would look like this format:

<CommandLine> "C:\Program Files (x86)\Dynamsoft\SourceAnywhere Client\SAWSCmd.exe" 7777 Michael Abc123456 default $/ get "($Message)" "" "($ScriptsFolder)" </CommandLine>

The above lines are copied from SAWS.xml. "C:\Program Files (x86)\Dynamsoft\SourceAnywhere Client\SAWSCmd.exe" is the path of SAWSCMD.exe.

6.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".


7. In the Link to Source Control dialog box, choose More. Specify the location of the working folder, and select SAWS as the current source control system. Click Link to link the database to SourceAnywhere.

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

Article Details

Last Updated
11th of October, 2016

Would you like to...

Print this page Print this page

Email this page Email this page

Post a comment Post a comment

Subscribe me

Add to favorites Add to favorites

Remove Highlighting Remove Highlighting

Edit this Article

Quick Edit

Export to PDF

User Opinions (0 votes)

No users have voted.

How would you rate this answer?

Thank you for rating this answer.

Related Articles

No related articles were found.


No attachments were found.