PDA

Click to See Complete Forum and Search --> : [RESOLVED] A trimmed down Source Safe

FishGuy
Jan 12th, 2006, 10:57 AM
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
Jan 12th, 2006, 11:40 AM
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
Jan 12th, 2006, 01:30 PM
What you can have Access mdb's in source safe?
si_the_geek
Jan 12th, 2006, 01:41 PM
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
Jan 12th, 2006, 01:54 PM
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
Jan 12th, 2006, 02:22 PM
Cool thanks guys I thought it was just code files, I'll experiment tomorrow at work! :)
RobDog888
Jan 12th, 2006, 03:56 PM
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
Jan 12th, 2006, 03:57 PM
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
Jan 12th, 2006, 04:03 PM
I have some 3rd party programs in there too. :D
Images for websites, html pages, js files etc.