Re: synchronising databases

Oracle Change Manager (change management pack for OEM) definetely can help you with metadata. It also can replace A+B with A+C along with propagating metadata changes (not a big deal, right). As far as I remeber it can't merge 'data sets'.

It'd be rather difficult to develop such a tool. To merge two data sets a knowleadge of an application is required. Think ref constraints, triggers, calculated columns, columns filled from (overlapped) sequences etc. Of course your case may be trivial, otherwise - good luck :)

Cheers,
Igor

ht_news_at_hotmail.com (ht) wrote in message news:<950c80fd.0204112249.41e8891b_at_posting.google.com>...
> Your're right but we need to figure out a way to maintain the added
> data in the target database since the last sync. We can not just
> discard it...
>
> Target database contains data set: A + B
> Source database contains data set: A + C
>
> Target database should contain (after the sync) data set: A + B + C
>
> Any idea's on that one?
>
> Greetings HT
>
> Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<38r8bu87a4fdtoe80gunkrnh9ulh3d29ll_at_4ax.com>...
> > On 10 Apr 2002 01:57:49 -0700, ht_news_at_hotmail.com (ht) wrote:
> >
> > >2 simalar database that have been apart for a while now should be
> > >synchronised again.
> > >Some meta data has been changed which needs to be synced and ofcource
> > >also the data in all the tables needs to be updated.
> > >Does anybody has a nice solution for this? Please help.
> > >Greetings ht.
> >
> > The obvious solution would be
> > - drop the user in the target database
> > - recreate the user in the target database
> > - export the data from the source database
> > - import the data into the target database
> >
> > Your databases are now in sync again.
> > If this is going to be a 2-way process, why didn't you use Visual
> > Source Safe to make sure all definitions are identical?
> >
> > Regards
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
Received on Fri Apr 12 2002 - 04:20:41 CDT