SQL Source Safe
-
Hi all
Out development team needs a SQL Source Safe solution to use for T-SQL scripts. As you know, developers sometimes concurrently work on the same sp and accidentally overwrite each others' script. The solutions that I found so far provide check-in/check-out mechanisms but they do not prevent developers from using regular Query Analyser Interface. Therefore, developers can alter scripts without having to check-out objects.
Can anyone offer a solution to this problem?
Thanks in advance...
-
Hi,
Unfortunately, this is the case with all source control - even with source control for regular files. There is nothing to stop a developer updating the file outside of the source control application.
However, you'd at least expect the source control to tell you if the underlying procedure has been edited outside of the source control application. Which is what SQLDBcontrol does (shameless plug I know
).Anyway, the cool thing about this application is that it integrates with SQL Server so when you check in an sp it will automatically update the sp on the SQL Server. If the sp has been changed on the SQL Server, when you check it in you'll get a warning indicating that it's been changed outside of source control.
It also has an integrated query editor with intellisense that makes it easy for developers to actually write sp's in something better than a text editor. The point being that it provides an environment that makes it easy to develop in and hence take advantage of the source control.
Anyway, download it (link in signature). If you have any queries, mail me.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply