Please follow the steps below to integrate SourceAnywhere Hosted with Red Gate's SSMS:
(Note:
The process is based on SourceAnywhere Hosted 3.0.1. If you are using an
old version, please upgrade to the latest version first.)
1. Install SourceAnywhere Hosted COM SDK. You can download it here.
2. Back up SAWHCmd.exe located at the installation folder of SourceAnywhere Hosted.
3. Download a new "SAWHCmd.exe" file and a file called "Interop.SAWHSDKLib.dll" and put it to the installation folder of SourceAnywhere Hosted.
http://www.dynamsoft.com/download/Support/SAWH3.0.1/SAWHCmd.zip
3. Download SAWH.zip and unzip the file to
"C:\Documents and Settings\{username}\Local Settings\Application
Data\Red Gate\SQL Source Control 2\CommandLineHooks".
http://www.dynamsoft.com/download/Support/SAWH3.0.1/SAWH.zip
4. Modify SAWH.xml accordingly. The below lines are copied from SAWH.xml:
<CommandLine>"C:\Program Files\Dynamsoft\SourceAnywhere Hosted Client\SAWHCmd.exe" OrganizationID UserName pwd repository serverfolder get "($Message)" "" "($ScriptsFolder)" </CommandLine>
"C:\Program Files\Dynamsoft\SourceAnywhere Hosted Client\SAWHCmd.exe" is the path of the new SAWH.exe.
For example, you can change it to be like the below line:
<CommandLine>"C:\Program Files\Dynamsoft\SourceAnywhere Hosted Client\SAWHCmd.exe" 108778 admin 123 test $/ get "($Message)" "" "($ScriptsFolder)" </CommandLine>
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 SAWH as the current source control system.
Click Link to link the database to SourceAnywhere Hosted.
Now, you can right-click on the files in the database to add files/modifications to source control.
