Devart Forums

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.

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/