My team is developing a new version of a server software that must support several clients via a web service interface. This software was written in C# and published on IIS. It also uses a Microsoft SQL Server database.
The problem is that our client has requested that we maintain two or more versions of the software running at the same time, so we have created separate URLs that run each of the different versions, for example the following URLs contain the versions 1.0.0, 1.5.0 and 2.0.0 of the software: "http://server/software_V100/service, http://server/software_V150/service, http://server/software_V200/service".
Unfortunately all of those versions share the same database, therefore some of the stored procedures we created for the 1.0.0 version were changed in the versions 1.5.0 and 2.0.0, so we decided to add the current version to the procedures' names just like the URLs, for example the DoSomething.sql procedure in version 1.0.0 became the DoSomething_V150.sql procedure in the version 1.5.0.
Because of this we are expecting that our software will become an incredible mess before long, therefore we decided to look into a version control software that would tell us what stored procedures belong to which version of the software, which ones were added, which ones were modified, etc.
Currently we are using the Microsoft Visual Source Safe to store the source code, however we were looking for a program that would give us a chart of which procedure belongs to which version of the software.
Could someone please recommend me a program that does that?