[RESOLVED] A trimmed down Source Safe

[FishGuy]

On behalf of our small IT team Im looking to develop a kind of source control application, to solve the problems of the given scenario.

In our company we have many small applications which although use SQL Server for a backend still use MS Access for the Interface. It is not feasible to rewrite these apps but as the development team is growing and different people a constantly making changes to the apps we need someway to control the changes.

I would like to make it so a user is forced to ineffect check out the mdb's when they work on them, then other users can see whether work is in progress and by whom along with details of work history.

Any Ideas of how to actually implement this, I would be grateful.

[techgnome]

Push the files into Source Safe... same as anything else you would control in SS.

Then make it a policy that violations of checking it out & making changes & checking back in are punishable by death from "various means." Then when a violation happens, the team gets to vote on the method used. And show no mercy.

-tg

[FishGuy]

What you can have Access mdb's in source safe?

[si_the_geek]

You can put any files you like in to Source Safe

You don't get all the same features as with code files, but you can store different versions & comments etc.

[RobDog888]

You can put anything and everything is VSS. You get some useful tools and features. Some are like versioning, code comparisons between versions showing differences and equalities, rollback to a previous selected version of a file/code, etc.

[FishGuy]

Cool thanks guys I thought it was just code files, I'll experiment tomorrow at work!

[RobDog888]

Oh, what I do for Access databases or other large files, is to zip then up irst before adding them to VSS. This reduces the size and if its Acces do a Compact and Repair first to reduce and clean the db first.

[techgnome]

Yeah, you can put any kind of file in to SS... We store SQL files in there, DLLS, code files... all our icons for our app.... Word Docs... Excel files, Visio diagrams.

-tg

[RobDog888]

I have some 3rd party programs in there too.
Images for websites, html pages, js files etc.