We have many different applications. Should I create separate sourcesafe databases for each application or should I create one database with multiple projects
The advantages of the latter are obvious in that all code can be seen at once. Our company uses contractors on a regular basis however and it would be nice to only give them access to the application they are working on.
What are people's thoughts on this
Thanks.
Multiple projects or multiple database???
davemord
Hi
Yes, you highlighted two of the main concerns. Ease access by have a central database and security in limiting access to contractors.
You should try to keep the database under 5 gig in size so if combining applications into one database will make your database start to approach this size you might want to keep them seperate.
If you have any data you absolutely has to be secure from other users you should put that data in a seperate database and only allow limited access too.
SourceSafe has a mechanism to hide some of the data in a central database from view to some users by setting SourceSafe internal security and not granting read or update access per project but this should not be confused with true security.
There is also the matter of what makes sense if you have 5 users that will only need to access project 1 and no one else needs to have access then probably should be in a seperate database.
If certain users will need access to all the projects then rather than have then need to jump from database to database centrally storing all projects in the same database has its advantages.
good luck
Simone1
Check this thread:
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=261168&SiteID=1
If access rights separation is needed then the only sure way to do so is put your projects in different databases.
But then again if one can check-in some code, that you are going to run (debugging your code) on your computer then potentially your computer is compromised (you are running code someone else gave you and there are ways to obscure what code does). Perhaps TFS would be a better choice for you where you can have true rights separation and can keep track of who checked in what and take action when some malicious code is checked in.