Pretty much any developer with half a brain (or any real world experience) knows that you MUST keep your source code in some sort of source code repository. There are many of them out there, VSS, Vault, TFS, CVS, SVN, the list goes on.
If putting your code (C#, C++, VB, etc) into a source control system is considered standard practice, why do shops still not put their SQL scripts into the same source control system. I know that there really is NO good way to integrate sql IDE's with source control systems, but deal with it.
We ran into a scenario yesterday here at work where a proc was changed, but we have no idea why or by whom. We are do not put our sql scripts in any scs system (against my protests an rants). We would not have this issue if everything was in an scs.
Can someone tell me why sql scripts are special?
Till next time,
11-21-2007 8:28 AM