Re: combining db's- importing primary keys

On Jul 29, 2009, at 8:26 AM, nha wrote:

> Hello,
>
> Le 29/07/09 15:02, Jasen Betts a écrit :
>> On 2009-07-27, Bob Gobeille <bob(dot)gobeille(at)hp(dot)com> wrote:
>>> I would like to combine multiple databases (same schema) into one
>>> master db. Does anyone know how I can reconcile all my primary and
>>> foreign keys to maintain referential integrity.
>>
>> prefix them all with something that's unique to their source
>> database.
>>
>> easy to say, hard to do.
>>
>
> A process (and solution) may be different whether:
> -the master db will replace all other databases (ie. data manipulation
> would directly perform on data managed by master db);
> -or the master db will reflect a combined view of data hosted by all
> other databases (ie. data manipulation would still perform on
> distributed databases and master db would play a role of federated
> view);
> -or both (data manipulation have to be manageable at the both side: on
> master db and on distributed db).

In my immediate case, I'm simply combining 7 global databases into a
single master.

Eventually, I would like to allow our (fossology.org) users to
subscribe to data in other databases. That is, allow
users to do periodic one-way batch updates from other servers.

Bob