How to automatically synchronize two oracle databases in interval

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
dhles2002
Posts: 1
Joined: Tue 05 Sep 2017 01:44

How to automatically synchronize two oracle databases in interval

Post by dhles2002 » Tue 05 Sep 2017 07:54

Dear support team,
I have two identical oracle databases I'd like to setup them to automatically synchronize in interval. This means the source database will synchronize its structure and data to target one in interval (5 or 10 minutes for instance).
Thanks.

alexa
Devart Team
Posts: 2430
Joined: Fri 24 Jun 2011 14:17

Re: How to automatically synchronize two oracle databases in interval

Post by alexa » Tue 05 Sep 2017 14:13

You can compare/synchronize database structures with dbForge Schema Compare Oracle https://www.devart.com/dbforge/oracle/s ... nload.html

With another our product dbForge Data Compare for Oracle, you can compare and synchronize table data https://www.devart.com/dbforge/oracle/d ... nload.html]

The Professional Edition of another our product dbForge Studio for Oracle fully includes the functionality of both dbForge Schema Compare Oracle, Professional and dbForge Data Compare for Oracle, Standard https://www.devart.com/dbforge/oracle/s ... tions.html

Also, with the help of the command line interface of the products and, for example, Windows Task Scheduler which will run the command line interface of dbForge in specific time intervals, you can automate the process. It will be possible to specify a batch of command line strings in a *.bat file.

Please see the following topics in the products' Help documentations:
https://www.devart.com/dbforge/oracle/s ... d_line.htm
https://www.devart.com/dbforge/oracle/s ... d_line.htm

The following articles for another our product would be also of help:
http://blog.devart.com/how-to-setup-dai ... ndows.html
http://www.devart.com/dbforge/mysql/stu ... ackup.html

Additionally, you may be interested in dbForge Compare Bundle for Oracle https://www.devart.com/dbforge/oracle/compare-bundle/

Post Reply