Re: How does one 2 seperate database instances in sync??

johnh_at_nnshh127.uucp (John Hawkins) writes:
>Need to be able to keep both instances in sync, preferrably on request.
>For instance today I would like to add all of europes 'new' data to
>the us instance and vice versa.

Use INCREMENTAL exports and imports. This might be a BIG headache. Use Oracle V7. Whoops, they might not have all the same data. Or be connected in real-time all the time.

Label each record with its source (US Created, EU Created, plus a date/timestamp for last modified) and exchange only those records which are new or have changed.

>possible same parent for child relationships.
>Need to insure data integrity.
>Any and all replies thanks in advance.
>John Hawkins
 

-- 
Andrew Finkenstadt, Vista-Chrome, Inc., Homes & Land Publishing Corporation
GEnie Unix RoundTable Manager, andy_at_vistachrome.com, andy_at_genie.geis.com.
"[The author] neither accidentally nor intentionally omits or includes 
anything that could support a preconceived thesis." - C&EN 21-DEC-92 p.72