by I am in the midst of developing a large scale SQL server driven
application that we are going to have to ship in various stages of
completion with the intention of 'catching up' the final version when
it's completed (I know, I know - it wasn't -my- decision)...
The problem being that the database desing is going to drastically
change along the way. I need something like 'source control' for SQL
server that can do some of the following :
1. Track changes to db objects (tables, stored procedures, triggers,
etc.)
2. [hopefully] Automate scripting to update changes to existing older
db objects while preserving their data <gulp>.
3. Even better - totally automate the whole process 8-)
If I have to manually go thrugh and come up with "bcp out, script
changes, bcp in" for various points along the way it is going to be a
nightmare... I have got to imagine that other developers are
going/have gone through this...
Is there anything out there that will handle things like this?
Anything even close?
Most Sincerely,
Jeffrey J Saylor