A tool that helps compare two Oracle databases and synchronize them.
dbForge Data Compare for Oracle, v3.5 is a quick and easy tool for comparing and synchronizing Oracle databases. It lets you compare different tables. Having found the differences, this tool will automatically generate a script to bring both the copies to the same status, eliminating the differences. This has a simple and easy to use interface. It is intuitive enough that most users should get familiar with it quite easily. Getting productive with it should not take much time. It offers a graphical wizard in addition and will guide you through the data comparison and synchronization process in simple steps. This automatic process will save you significant amount of time when you need to keep copies of a database in sync. Analysis of the data bases are carried out accurately and you can obtain a range of reports.
The synchronization script is SQL compatible. This can provide a simple way to copy data from the development database to the production database copy. The comparison goes quite deep. The tool not only compares tables, views and materialized views but is able to compare data with different structures. Multiple schemas could be compared at the same time. It is possible to use the “WHERE” clause as a filter for extra large tables or custom data comparison. Data in LOB and BFILE columns can be synchronized easily too. Scheduled sync operations can be carried out with the command-line interface. The settings used could be saved and used again. This tool is compatible with Oracle versions: 12c, 11g, 10g, 9i, and 8i databases and Oracle XE 11 R2, and 10. This is a very good product. If you are looking for a similar solution, you should try it in your exact workflow.