DbForge Data Compare for Oracle Product Review
Reviewer: Helena G
Date: June, 2010
dbForge Data Compare for Oracle is a powerful, fast, and easy tool for comparing and synchronizing Oracle databases. It helps you quickly compare data in tables, find the differences at a glance, and generate a script to effortlessly synchronize data. All this is done in a clear graphical interface. Database professionals use dbForge Data Compare to:
- Compare data in Oracle databases to detect changes
- Analyze data differences between two databases
- Synchronize two databases that went out of sync
- Generate data comparison reports in Excel and HTML formats
- Generate SQL*Plus script to update data in one database to match another
- Copy look-up data from development database to production
There was a great necessity to invent a reliable tool to compare and synchronize data in Oracle databases fast and with little skills. It is no secret dealing with Oracle databases requires great mastery as well as patience. Having accumulated extensive experience in developing SQL Server and MySQL data comparison tools, Devart team was ready to deliver dbForge Data Compare for Oracle. The tool was designed to unlock the complexity and make Oracle database management accessible to a broader circle of database developers, administrators, and users.
dbForge Data Compare for Oracle, v1.0 was released on August 12, 2010 as a free tool to replace hours of manual work in command-line with minutes in convenient wizards. The design and capabilities of the new tool were perfectly tailored to reduce slightest misunderstanding and prevent possible complexities in everyday usage in fast-pace environment by either a database pro or a newbie. dbForge Data Compare for Oracle used any opportunity to save even a minute, and dramatically optimize comparison and synchronization. It introduced a start page with the list of previous comparisons that could be recompared with a click, allowed saving comparison settings as comparison projects for the next usage, and automatically grouped comparison results by status to reduce time for analysis.
Being a free tool, dbForge Data Compare for Oracle has become the most affordable way to enjoy automatic data comparison and synchronization in Oracle databases. Wide support of Oracle databases (11g, 10g, 9i, 8i, 7.3) and high-speed automatic comparison have removed all the anxiety and errors that usually follow this process, delivering an absolutely clear, fast and pleasant way of Oracle database comparison. Facing the challenge to simplify Oracle table data comparison and synchronization even more, Devart team continued working in a close collaboration with people who perform such tasks daily or occasionally. These days Devart is close to release dbForge Data Compare for Oracle, v 2.0 – a more versatile tool blending great features, excellent performance, and pleasure to offer any database developer make the most of Oracle database capabilities.
The 3.0 version has been released in the middle of 2011 and contained new extended data comparison reports, custom query result comparison and many other improvements, such as more flexible comparison settings and improved analysis of comparison results.
The 3.5 version has been released in December, 2013. The update contains the new features such as Oracle 12c support, code completion and SQL Code Formatter, and minor functionality improvements. In dbForge Data Compare for Oracle, v.3.5 database objects are described faster now, working with Oracle on Amazon RDS is possible now, snapshot creation functionality is added.
The 3.6 version has been released in July, 2014. The new features include connection via Windows authentication, Include Print Comments option, Use SQL *Plus Commands option and ability to view results as a structured XML file.
Installation is always easy and quick. It takes to double-click the exe file and follow the prompts in the wizard. Upgrade is done through the same wizard and is easy too.
 Price and availability
For more information about the product, go to the Product website. Here you can watch a product demo, download a free Express edition or a trial version of the Standard edition, and buy the product licence.
Visit the Editions page to see the differenceу of functionality between the two Editions.
License price: Express – free, Standard - $149.95
- 30-day fully functional product trial
- 30-day money-back guaranty policy
- free 1-year subscription for updates and technical support
dbForge Data Compare for Oracle goes beyond ordinary data compare tools featuring powerful functionality while preserving a clear GUI and simple logic. Paying attention to a human factor, the tool does its best to deliver the safe and accurate data comparison and synchronization in Oracle databases. In modern face-pace environment with ever-growing Oracle databases and data in them, dbForge Data Compare for Oracle is a reliable solution to ensure the quality of synchronized data and efficiency in managing Oracle databases.