How customizable is SourceGear?

[ThreePea]

Hello.

We are investigating a replacement for VSS. Our options are:
1. Deal with VSS and its issues (it's working ok for us, but we feel limited)
2. Write our own.
3. 3rd-party replacement, like SourceGear.

We have already built our own Deployment application, which allows us to deploy SQL procedures and ASP/.NET files in a single cart to our webservers. It integrates with VSS to a point, getting and giving information where applicable. It's pretty slick.

We feel it would be fairly trivial to extend our Deployer to add source control. But we're super busy, so if someone else has already done it, why reinvent the wheel.

Which leads me to my main question. I know SourceGear uses SQL Server. This is great for us, since we are a huge SQL Server shop. But to what extent can we modify or extend SourceGear functionality? For example, when we check out a file in SG we would want it to automatically create a cart in our Deployer (basically, executing a sql stored procedure). Is this sort of thing possible?

(Sorry if this was answered elsewhere. I searched the forums and read the FAQ and didn't find it).

Thanks.

Jerry
CTO
Plexus Systems
___________________
Plexus Online - the first and only completely on-demand manufacturing solution.
www.plex.com

[jclausius]

Jerry:

I don't know if there are enough events covered to do what you want, but you might be able to accomplish some of these tasks through the Vault Plugin architecture.

For example, when someone commits changes to a repository, a web service plugin is called.

Here is a blog posting with a bit more info - htttp://weblogs.asp.net/jeremy_sheeley/archive/2004/04/07/109102.aspx

You may also want to search these forums for "vault plugin", as I believe there may be other users who have written their own Vault plugins.