DbForge Data Compare for Oracle Product Review

From Oracle FAQ
Jump to: navigation, search

Reviewer: Helena G

Date: June, 2010

Summary[edit]

dbForge Data Compare for Oracle is a powerful, fast, and easy tool for Oracle database comparison and synchronization. It helps you quickly compare two tables, find oracle diff tables at a glance, and generate a script to effortlessly synchronize data. All this is done in a clear graphical interface.

dbForge Data Compare has the following features:

  • Wide support for Oracle server versions and objects to be compared:
Support for all Oracle versions
Working with Oracle on Amazon RDS
Work without Oracle client (Oracle Direct connection)
Compare and synchronize data in tables, views, materialized views, custom queries, databases with different structures, multiple Oracle schemas
  • Comparison and synchronization options
Include tables or views into comparison by mask or individually
Exclude objects from comparison by mask or individually
Ignore columns by mask
Float types rounding option
Ignore Case and Ignore Trailing Spaces options for string comparison
LOB comparison options
WHERE filter for limiting data that needs to be compared
User mapping allows comparing tables with different names and columns
Map one table in source with two or more tables in target
Custom Query feature allows comparing a table with a query result
  • Data comparison and analysis
Filter and sort objects in result
View data differences for each pair of objects
Perform full-text search in data differences
View number of changes per column
Hide unmodified columns to simplify analysis
Generate data comparison report in Excel and HTML formats
Include actual data into report
Report on selected objects only
  • Automate routine tasks
Save comparison project settings for future use
Save settings to a command line arguments file
Compare data
Multiple ways to sync data (execute script, save synchronization script)
Generate data report
Execute script
Format script
  • Sync data
Multiple ways to sync data: create and open, execute, save synchronization script
Migrate individual records, groups of records, or all data differences
Toggle synchronization direction to apply data changes to both databases
Rollback changes on error
Synchronize LOBs via files
Warnings on possible problems prior to synchronization

History[edit]

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 was 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.6 version was 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.

The 3.7 version was released in February, 2015. The update includes an ability to ignore difference in end of line option, query execution pane and command-line interface for SQL formatting.

The 4.0 version was released in November, 2016. This release brought significantly redesigned Data Comparison UI, support connection to Oracle server via IPv6 and redesigned installation wizard. Greatly improved suggestion performance, improved XML View and new JSON View for Data Editor and Viewer Window, styled icons are used by default, data type information to the column header in Data Grid added.

Installation[edit]

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[edit]

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

Benefits:

  • 30-day fully functional product trial
  • 30-day money-back guaranty policy
  • free 1-year subscription for updates and technical support

Conclusion[edit]

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.