Howto make a legacy database distributed?

I'm looking for a tool which makes a legacy database distributed without many changes of database structure. The goal is to work separate on each database (like stand alone) and to merge the changes at an separate step. Each database has initially the same content and changes of one database must propagate to the others.

The following problems must be solved:

• primary key conflict (each side as created an record with the same key but different data; one of the records must be moved to an unused key)
• foreign key conflict (one side has a record deleted on which the other refer)
• no possibility to connect to two databases at one time (changes must be transmitted for instance within a file)

If no such tool is known, a paper would also help.

Thanks, Ronald.

PS: A replication like supported by sybase does not solve the

    problem because there are need of an extensive redesign     of the database (e.g. a pool of PK's).

Sent via Deja.com
http://www.deja.com/ Received on Fri Feb 02 2001 - 12:02:24 CET