Help: Database Version Management Software???

Help: Database Version Management Software???

Post by jeff sayl » Mon, 22 Sep 1997 04:00:00



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

 
 
 

1. Help: Database Version Management Software???

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 to
clients 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 databases 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?

2. MAC Classified Doc Mgr

3. New version of Intellisys Project Management software released

4. NewEra 2.2 Superfield focusout() not working!!

5. Database version management

6. Problems with MS Access and Java app

7. DC-Washington-255054--Project Management-Software Engineer-SYBASE-ORACLE-Project Manager, Software Engineer

8. IL, Chicago / Software Database Management Specialist (RECRUITER)

9. Database to Run Clarify Call Management Software

10. Database backup to ADSM (or other data/media management software)