Our shop is currently developing software using Visual Studio 2010 and SQL Server 2008. We're storing all of our source code in Visual SourceSafe. To be frank, SourceSafe is not that good. It's old and clunky and not very good at reverting code back to previous
versions.
For SQL, we're scripting all of our database objects out to disk and then adding them to VSS. It works, but is cumbersome too.
I want to find something else that will work in both environments. Any suggestions?
I would also prefer Team Foundation Server or Team Foundation Services, but there you would normally also script your database and check-in the resulting .sql files into TFS.
Regards.
If my post solves your problem, please mark as answer.
rgcazo
Member
410 Points
94 Posts
Version Control
Jan 15, 2013 12:54 PM|LINK
Our shop is currently developing software using Visual Studio 2010 and SQL Server 2008. We're storing all of our source code in Visual SourceSafe. To be frank, SourceSafe is not that good. It's old and clunky and not very good at reverting code back to previous versions.
For SQL, we're scripting all of our database objects out to disk and then adding them to VSS. It works, but is cumbersome too.
I want to find something else that will work in both environments. Any suggestions?
Thanks.
Applications Development Supervisor
CruzerB
Contributor
5399 Points
1098 Posts
Re: Version Control
Jan 15, 2013 01:15 PM|LINK
Hi,
Team Foundation Server is the best source control tool that I ever use.
http://tfs.visualstudio.com/
Right now, Microsoft has offer free account for light weight users. You may try it.
My Technical Blog
Horizon_Net
Star
8277 Points
1435 Posts
Re: Version Control
Jan 16, 2013 08:31 PM|LINK
Hi,
I would also prefer Team Foundation Server or Team Foundation Services, but there you would normally also script your database and check-in the resulting .sql files into TFS.
If my post solves your problem, please mark as answer.
jprochazka
Contributor
4876 Points
740 Posts
Re: Version Control
Jan 16, 2013 09:43 PM|LINK
Here are a couple posts I made in the past reguarding version control software.
I hope you find them useful in making your decision.
http://forums.asp.net/post/5128889.aspx
http://forums.asp.net/post/5226824.aspx
Currently at work we are using Subversion.
For personal and side projects I prefer Git.
Both are great SCM systems.
I prefer Git outside of work due to the fact it is distributed revision control and much more portable than Subversion.
You might want to look into Data-Teir Applications which integrate better into a source control environment.
http://msdn.microsoft.com/en-us/library/dd193245(v=vs.100).aspx
For Visual Studio 2008 you may need to go with a Database Project however.
http://msdn.microsoft.com/en-us/library/dd193245(v=vs.90).aspx
Both methods however should work better in a source control environment than manually scripting the database constantly.