Re: Database Modifications...

Hi,
I have been using a rather good tool from www.bitbybit.co.uk called CHECKMATE
for about 2 years now. It allows me to record the schema and then compare it with one I had last week. I time stamp my shemas. We have about 5 patches per day so software versions don't really mean anything. I do this everyweek. i can also produce mini databases by extracting all related data for 1000 clients in my production or copy of database. I then inject this in to a waiting db for my developers. It saves an awful amount of disk space. 100GB to 8GB
Peter

Jeff Kwan wrote:

> Hi, I've got a question concerning database modifications. OK here's
> our situation, we have a rather large database structure (lots of tables
> and constraints) and we're in constant development, so the database
> structure changes a bit between versions of our software. Now, we have
> clients that may have a certain version of software/database
> combination, not the latest version, but eventually we want to upgrade
> them to the latest version (lots of bug fixes, etc).
> ...

> I've played with PowerDesigner DataArchitect and modification orders
> are pretty cool, but the problem is that the databases in the field may
> not match those in our physical models to the "T." Any suggestions from
> people on "upgrading" databases? (tools, etc?)
>
> -Jeff
Received on Tue Sep 01 1998 - 16:52:37 CDT