DbForge Data Compare for Oracle Product Review
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
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.
The 5.0 version was released in August, 2018. This great update includes Oracle Database 18c connectivity support, new Data Comparison Options such as specifying regular expression for include/exclude tables or views by mask, ignore columns by mask, ignore whitespaces, exclude newly added objects, tolerance interval. Data Synchronization Options upgrade includes check for concurrency updates, synchronize current values of sequences. Expanded Comparison Reports functionality, exclusion and inclusion of columns from/into comparison, automatic selection of comparison key for object without equal unique indexes, improved visual style of tool, command line execution file wizard, trial product activation, support for PowerShell, FIPS compliance, specific exit codes were added.
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.
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 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.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.
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.
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.
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 differences of functionality between the two Editions.
License price: Express – free, Standard - $199.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.