change management for SQL source code

a question for you MVPs...
Is there a standard for SQL source code change management. I can do this wit
h all my VB & .NET code using SourceSafe and a build and deploy application
that validates all the source so I can deploy from a label giving me full ve
rsioning capability of my c
ode. Is there something out there that can do the same for SQL?
regards,
Mike Daviesmike
I am not a MVP as you have asked but let me give you some article to read
http://www.sql-server-performance.c...managemenet.asp
"mike davies" <anonymous@.discussions.microsoft.com> wrote in message
news:8A57742F-51CE-4CED-8F30-091C0AC1BA60@.microsoft.com...
> a question for you MVPs...
> Is there a standard for SQL source code change management. I can do this
with all my VB & .NET code using SourceSafe and a build and deploy
application that validates all the source so I can deploy from a label
giving me full versioning capability of my code. Is there something out
there that can do the same for SQL?
> regards,
> Mike Davies|||Unfortunately there still doesn't seem to be a tool that can help me with my
process. With my procedural code (VB and .NET code) there are many applicat
ions out there that give me what I want. I know there are tools that say the
y provide change management
- but they are, are tools to show the differences between databases. How do
I know the database is a reflection of my source code? I could still be depl
oying broken code. Sadly they are lacking and claim to be something they are
not.
Doesn't anyone know of a tool that can give me the auditability of my source
code that I desire.
regards,
Mark Baekdal