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.
How to automatically synchronize two oracle databases in interval
Re: How to automatically synchronize two oracle databases in interval
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/
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/