> I make a system, deliver to a customer, I change the system, make
> integration utilities, deliver demos, changing demos, and in the end
> I have a variaty of DB versions and an administration of those that
> kinda consumes a lot of time.

Software management can be a pig.

> I am looking for a module, collection component or any system that
> gives me complete consistancy control. Something that enables me to
> design a database and, on command, pick up any DB-file and update to
> match it up to the design. Any changes in table or field definitions,
> triggers, indexes, keys... everything.

A tall order!

> Any suggestions?

I use BeyondCompare ( as does Jason ) to monitor all changes
and keep track of what has changed from version to version.
In order to control the database stuff, I use Marathon and
export the metadata as a text file so that I can manage it
the same way.

Not a simple single click solution, I don't think we can
have that, the script that comes out can be used to create
an update script. BUT if there are major changes the I
always build a clean blank database, and pump the onsite
data into it. That way the old version is always available
in emergency, and any problems that have not been picked up
in testing do not trash the new setup.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services