Re: synchronising databases

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 10 Apr 2002 18:50:52 +0200
Message-ID: <38r8bu87a4fdtoe80gunkrnh9ulh3d29ll@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 Wed Apr 10 2002 - 11:50:52 CDT