Home » Server Options » Replication » Replicate table
Replicate table [message #75360] Thu, 24 April 2003 05:22 Go to next message
Tabrez Mulla
Messages: 1
Registered: April 2003
Junior Member
Hi All,

I have an application which writes similar data to two different database. This application has two processes and each one writes to a different database instance.
If one of the process or database goes down, the other process will keep writing to other database.
My question is how do I synchronize these two databases when the downed process or the downed instance is brought back up.
Is there a tool that will help me do this.

Regards
Tabrez Mulla
Re: Replicate table [message #75382 is a reply to message #75360] Wed, 16 July 2003 16:19 Go to previous message
David Simpson
Messages: 29
Registered: May 2002
Junior Member
Tabrez,
You may want to look at the "reconciling replicated tables" section (near the bottom) of the following web page for a query which may help you:
http://www.dotcomsolutionsinc.net/products/repgen/repgen_example_repdoc1.html

Then you can manually copy the missing records between the two databases.

David Simpson
http://www.dotcomsolutionsinc.net

Previous Topic: Is 1-to-many replication possible?
Next Topic: materialized view refresh
Goto Forum:
  


Current Time: Mon Sep 27 12:44:42 CDT 2021