dbForge Data Compare for Oracle: Find the Rows That Differ, Then Script the Fix
dbForge Data Compare for Oracle is Devart's Windows tool for comparing the data in two Oracle databases or schemas, row by row, and generating the SQL*Plus script that makes the target match the source. It costs $119.95 a year (or $229.95 for a perpetual license) and is aimed at DBAs and developers who copy lookup data, verify replication or move data changes between development, test and production.
A price list that's right in development and wrong in production, a reference table someone edited by hand on staging, a replication job that silently skipped a few hundred rows: these are data problems, not schema problems, and a schema diff won't show them. Data Compare lists every table with how many rows differ, exist only on one side or are identical, and lets you sync just the ones you pick.
Quick facts
- Version: 2026.2.96, released November 9, 2026
- Developer: Devart
- Platform: Windows 7 to 11 and Windows Server 2008 to 2025, with .NET Framework 4.7.2
- Databases: Oracle 8i through 23ai and 26ai, Oracle Cloud, Real Application Clusters and Oracle on Amazon RDS, with or without an Oracle client
- Compares: tables, views, materialized views and your own custom queries, across one or several schemas
- Edition: one edition (Standard), sold as a 1-year subscription or a perpetual license
- Download: 121.87 MB; the installer is Devart's Compare Bundle for Oracle, which also contains Schema Compare
- Price: $119.95 a year, or $229.95 perpetual with a year of updates
- Trial: 30 days, full functionality (the download asks you to sign in with a free Devart account)
- What we checked: version 2026.2.96 and its November 9, 2026 date on Devart's download page and revision history, the 121.87 MB download size listed there, the Oracle versions in Devart's requirements page, and the order page price of $119.95 for the default 1-year subscription (renewing yearly at the same price) and $229.95 for the perpetual license, on November 13, 2026. We didn't run a comparison against our own Oracle data.
Before you buy
- It compares rows, not structure. For tables, columns, indexes and PL/SQL objects you need Schema Compare for Oracle; the Compare Bundle for Oracle has both for $169.95 a year.
- A subscription stops working when it ends. The perpetual license keeps working after its year of updates; renewing it only brings new versions and support.
- Check the refund terms. Devart's order page promises a refund within 30 days if you're not satisfied (on annual subscriptions and perpetual licenses), but its ordering FAQ ties refunds to technical problems its support can't fix, so make up your mind during the trial.
- If you live in an Oracle IDE all day, dbForge Studio for Oracle Professional ($329.95 a year) includes data and schema compare.
Download Free TrialBuy Now
Overview
Data Compare for Oracle does one job. You pick a source and a target connection, choose the schemas, and the New Data Comparison wizard maps the tables and views by name. It picks a comparison key for each pair (usually the primary key), and you can change it or choose which columns to compare. After the comparison, every object is listed with counts of rows that are different, only in the source, only in the target and identical, and you can drill into any table to see the differing values side by side.
From there the Data Synchronization Wizard builds the script. You can open it in the built-in SQL editor, save it to a file, or run it straight against the target, and the summary shows the plan (drop foreign keys, update rows, recreate foreign keys, commit) before anything changes.
Devart ships builds often. The November 2026 release fixed an out-of-memory error with large Excel reports, October fixed WHERE filter validation and improved copying data into Excel, and September added activation by signing in and fixed an ORA-02421 error during data comparison.
Features
Column mapping and custom comparison keys
dbForge Data Compare for Oracle lets you choose the key used to match rows (any unique key, or columns you pick) and which columns are compared and synchronized, and it warns you when column types aren't fully compatible. That matters for tables without a primary key, where most simple tools give up.
The Column Mapping dialog for the COUNTRIES table: COUNTRY_C_ID_PK as the comparison key, with Key, Compare and Sync checkboxes for each column.
Tables, views, materialized views and custom queries
dbForge Data Compare for Oracle compares tables, views and materialized views, and also the result of your own query on each side, so you can compare a filtered subset or a join instead of a whole table. It handles several schemas at once and databases whose structures differ.
Results you can filter before you sync
dbForge Data Compare for Oracle groups the records of each object by status, lets you filter, sort and search the results, exclude whole objects or single records from synchronization, change the sync direction, and save the comparison to rerun later.
Comparing HR with HR_DEV: JOBS has 3 different rows and JOB_HISTORY 2, with the grid below showing the differing MIN_SALARY values.
A synchronization wizard with an action plan and warnings
dbForge Data Compare for Oracle generates a SQL*Plus script, warns about possible data loss, overflow and rounding before you run it, and lets you add your own scripts to run before and after the synchronization.
The wizard's Output page (open, save or execute the script) and its Summary: drop 4 foreign keys, update 3 rows in JOBS and 2 in JOB_HISTORY, recreate the keys, commit.
Reports and command-line automation
dbForge Data Compare for Oracle exports comparison reports to HTML, Excel and CSV, optionally with the actual data and only the selected objects. Saved comparisons run from the command line, a generated .bat file or PowerShell, so Windows Task Scheduler can run a nightly sync or check.
The command-line execution file settings (source, target, schema mapping, report, synchronization) beside a console run of datacompare.com.
Benefits
- Data fixes you can review first. The action plan and warnings show what the script will do before it touches the target.
- No hand-written MERGE statements. The script is generated per table in the right order, foreign keys included.
- A repeatable check. A saved comparison on a schedule tells you when reference data drifts or replication falls behind.
Real-World Uses
- Deploying lookup data: copy new rows of a price list or code table from development to production with the release.
- Checking a replica: compare a reporting copy with its source after a load and sync the missing rows.
- Auditing a manual change: report exactly which records someone changed on staging, with the values.
- Comparing a subset: compare one customer's orders between two environments with a custom query.
Who It's For, and Who Should Skip It
Buy it if you're a DBA, developer or tester who regularly has to make table data match between Oracle environments, or prove that it does.
Skip it if your problem is structure (Schema Compare for Oracle), if you need both schema and data (the Compare Bundle costs only $50 a year more than this tool alone), if you already own dbForge Studio for Oracle Professional or Enterprise, or if you work on a Mac or Linux, since it's Windows-only.
Usage Guide
- Download and install the Compare Bundle for Oracle from Devart's download page (sign in with a free Devart account), and choose Data Compare.
- Start a new data comparison. Pick the source and target connections and the schemas to compare.
- Set options. Choose what to ignore and how to round or trim values, then check the mapping and comparison keys for each table.
- Compare and review. Filter the results, open a table to see the differing rows, and exclude anything you don't want to sync.
- Synchronize. Run the wizard, check the action plan and warnings, then open, save or execute the script.
- Automate. Save the comparison, generate a .bat file, and schedule it in Windows Task Scheduler.
Where It Falls Short
- No schema sync. Data Compare maps tables whose structures differ, but it won't create a missing column or index for you.
- Only one edition, so there's nothing to upgrade to inside the product: the bundle or the Studio are the next steps.
- Very large reports are heavy. Devart has had to fix out-of-memory errors with big Excel comparison reports, so huge comparisons push the tool.
- Oracle only. You need a separate Devart tool for SQL Server, MySQL or PostgreSQL data.
What Users Say
Independent reviews of this tool are few: SaaSworthy shows one rating (5 out of 5, collected from G2), and the bundle that contains it has three, all positive. Here they are, with two quotes from Devart's own product page.
Data Compare for Oracle on G2 (shown on SaaSworthy)
Harshvardhan S. (April 21, 2023): "This software provides a user-friendly interface for comparing and synchronizing data in Oracle databases quickly and accurately. I appreciate its ability to automate data synchronization tasks."
His one complaint: "dbForge Data Compare for Oracle is designed explicitly for Oracle databases and may not be suitable for users with other database management systems, which limits its efficiency."
Compare Bundle for Oracle users on G2 (shown on SaaSworthy, 5/5 from 3 ratings)
Oleksandr L. (June 17, 2020): "I use a lot the Generate SQL*Plus script feature to update data in one database to match another."
Katya O. (June 16, 2020): "Quick and high-level comparison of thousands of tables and their details"
A verified user in real estate (September 28, 2020): "It is able to handle extreme amounts of data."
Customers quoted on Devart's product page
Fredrik Lann: "We have previously used DbDiff for Oracle. It is not developed any longer, contains bugs, and does not support anything newer than Windows XP. I have already found out that dbForge Data Compare tool handles almost everything we did in DbDiff for Oracle and the interface is much better..."
Jerry Thill, Architect I, Origin Consulting: "I think the product is excellent and I use it daily.."
The pattern is consistent: people like the interface, the generated scripts and the automation, and the only real complaint is that it's Oracle-only. The sample is small and several years old, so treat the 30-day trial on your own largest tables as the real test.
Comparisons
Data Compare vs the Compare Bundle for Oracle
The Compare Bundle for Oracle adds Schema Compare for Oracle. The Standard bundle costs $169.95 a year against $239.90 for both tools bought separately, and $329.95 perpetual against $459.90. If you ever need to sync structure as well as rows, the bundle is the better buy.
Data Compare vs dbForge Studio for Oracle
dbForge Studio for Oracle Professional ($329.95 a year) includes data comparison and synchronization with its command line, along with schema compare and a full PL/SQL IDE. The Standard edition of the Studio doesn't include data compare. Buy Data Compare alone when you only need to sync data.
Editions and Pricing
Data Compare for Oracle has a single edition. The order page opens on the 1-year subscription at $119.95; you can switch there to a perpetual license, to 2 or 3 years of support, and add priority support.
| License | Price | What happens later |
|---|
| 1-year subscription | $119.95 | Renews yearly at $119.95; stops working if not renewed |
| Perpetual | $229.95 | Keeps working; includes 1 year of updates and support |
Devart takes 5% off for 5 to 9 licenses, 10% for 10 to 19 and 15% for 20 or more.
FAQs
Does dbForge Data Compare for Oracle need an Oracle client?
No. dbForge Data Compare for Oracle can connect directly to the server, and it also works with Instant Client or with several Oracle Homes on one machine.
Can it compare two schemas in the same database?
Yes. dbForge Data Compare for Oracle compares data between schemas of the same database as well as between different databases, and it can map several schemas in one comparison.
Can it compare tables that have no primary key?
Yes, if you give it a key. dbForge Data Compare for Oracle lets you choose a custom comparison key for each table pair in the Column Mapping dialog.
Does it work with Oracle on Amazon RDS or Oracle Cloud?
Yes. dbForge Data Compare for Oracle supports Oracle on Amazon RDS, Oracle Cloud and Real Application Clusters, as well as on-premises Oracle 8i through 26ai.
Can I run it from a script or scheduler?
Yes. dbForge Data Compare for Oracle runs saved comparisons and synchronizations from the command line, and it generates a .bat file you can run from Windows Task Scheduler or call from PowerShell.
What happens if I let the subscription lapse?
A dbForge Data Compare for Oracle subscription stops working at the end of its term until you renew. Devart charges 20% more to renew 3 or more months after the end, and 60% more after 12 months.
System Requirements
- Windows 7, 8, 8.1, 10 or 11, or Windows Server 2008, 2012, 2016, 2019, 2022 or 2025
- .NET Framework 4.7.2 or later
- Oracle 8i to 26ai, Oracle Cloud, RAC or Oracle on Amazon RDS
- About 122 MB for the installer download
Conclusion
dbForge Data Compare for Oracle is worth $119.95 a year to anyone who regularly has to make Oracle table data match between environments: the custom keys, per-row exclusion, warnings and command line turn a fiddly manual job into a reviewed, repeatable script. The main reason not to buy it alone is that structure changes usually travel with data changes, and the Compare Bundle adds Schema Compare for only $50 more a year. Try it free for 30 days on your own tables first.
Download Free TrialBuy Now