Re: synchronising databases

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 - 01:49:33 CDT