This may not be a MSSQL-specific question, but
I wanted to ask it here first, in case there's
a MSSQL and/or SourceSafe solution that will help.
Our dev team is having some difficulty with
keeping the nightly builds in sync with the
stored proc mods. I'm wondering if there are
some good case studies on how to avoid this
"drift". Something like genning a new DB from
checked-in SPs, etc. alongside each regular build,
then always have a paired enterprise app/database
duo that is tagged and added to a history.
FWIW, we have a 3-tier .NET/C# app, and
ADO.NET is throwing exceptions every other
day.
If the suggestion is to whip the DB guys, that
works for me as well. ;-)
Nah, there's much love there.
Thanks in advance,
~swooz