Kevin.Gao.Blog

This article explains how to source control stored procedures and other objects in SQL Server Management Studio 2008. We use SourceAnywhere Standalone for example, which is a SQL-based source code control software designed to be a replacement of Microsoft Visual SourceSafe. Other MSSCCI compatible source code control solutions work in a similar way.

The detailed steps are as follows:

1) Open SQL Server Management Studio.

2) Initiate source control for SSMS. Please click menu Tools | Options | Source Control. In the dropdown list, choose Dynamsoft SourceAnywhere Standalone 2.3 as the current source control plug-in.

3) If we have an existing application solution, we can click menu File | Open | Project/Solution to open it in Solution Explorer.
And then we can add the solution/project into version control. Right-click on the solution/project and then choose Add Solution to Source Control in the content menu.

You can also start a solution from the ground. Click menu File | New | Project and choose a proper template. Don’t forget to check the Add to Source Control option.

4) Put the correct server info and credentials.

5) In the project tree, choose a location to put the solution/project.

At the end of the step, the solution/project is under version control.

6) Now it’s time to add a new or existing stored procedure into the solution.

To create a new stored procedure, in Solution Explorer, we can right click on the project name and hit the Add | New Item menu.

Under SQL Server Query, navigate to the Stored Procedure category and choose a template.

Adding an existing store procedure is easier. Instead of selecting New Item in the Add popup menu, we choose Existing Item.

7) Finally, we can perform the basic source code control operations in Solution Explorer, such as Check Out and Check In, by right clicking on an object. All the objects checked out to be edited can be found in the Pending Checkins window.

If you want to try SourceAnywhere Standalone, please install its Windows GUI Clienton the machine where SQL Server Management Studio resides. The can be integrated with all MSSCCI compatible IDEs, such as Visual Studio 6.0, 2005/2008/2010. Downloaded link:
https://www.dynamsoft.com/Secure/Register_ClientInfo.aspx?productName=SAWstandalone&from=FromDownload

Good news for SourceAnywhere for VSS users. Version 6.0 is available today!

Users of SourceAnywhere for VSS would be very excited to find the interface changes made in version 6.0. In previous versions, our developers paid more attention to the functions/features of the product, expecting SourceAnywhere for VSS to be the fastest SourceSafe web access add-on tool. After many years’ efforts, I must say SourceAnywhere for VSS has become stable and mature. We received much positive feedback from our customers saying that they are very impressed with the robust features of the software.

In this background, when we decided to develop version 6.0, we focused more on making it “user friendly“. From the customizable skin type, menu bar & toolbars, dockable windows, working folder with “hyperlink”, to the improved error/warning messages, we want to make sure that SourceAnywhere for VSS a powerful yet easy to use tool.

I cannot wait to share one of the skin styles here:

In addition to the optimized user interface, many features are also added or improved in version 6.0: integration with Dreamweaver CS 5, improved “showing differences” feature on projects, support for sharing historical version of project and moving items in IDE clients etc. Upon our customers’ request, source control operations (Check In, Undo Check Out and Get Latest Version) on multi-files from different directories are also available in the Search Result dialog. To learn more about what’s new in version 6.0, please click here.

Here is the download link of SourceAnywhere for VSS 6.0 Trial:
http://www.dynamsoft.com/Downloads/SAW_TryIt.aspx

Productive Season! Following SourceAnywhere 2.3.1 and SCM Anywhere 2.2, Dynamic Web TWAIN 6.1 is released today.

Cookie/session integration has been supported by Dynamic Web TWAIN ActiveX since version 5.1 and is liked by many customers. This exciting feature is now added to the Plug-in edition.

Besides that, we added support for Forms Authentication to Dynamic Web TWAIN Plug-in Edition. And you can now remove selected images in the new version of Dynamic Web TWAIN. We also optimized the installation process of the Plug-in Edition on clients’ side. For more details, please check What’s new.

Annotation is a tough one. Our developers discussed a lot regarding this feature. Should we add the feature into Dynamic Web TWAIN? What kind of functions should be included if we decide to go this way? Finally, as per one of our customers’ suggestion, we decided to add a simple annotation feature first into version 6.1. Hope you enjoy it. All your suggestions and comments are very important to us to perfect the product.

To evaluate these new features in Dynamic Web TWAIN 6.1, you can download the trial version here.