Red Gate logo

Compare Oracle tables and deploy differences

See differences in records side-by-side and script up changes

Introduction to Data Compare for Oracle

Database diff tool for Oracle table data

  • Save time comparing and synchronizing data
  • Copy lookup data from development databases to staging or production
  • Troubleshoot and resolve errors caused by differences in data
  • Generate SQL scripts to update one database with the contents of another
  • Command line automation
  • Run Data Compare for Oracle on your build server for continuous integration (with the SQL Automation Pack)

$37

Licensed per user

Buy now

Volume discounts of up to 30% apply

Features

Compare and sync table data

Compare data in tables across schemas and see differences. Drill down through individual records or group them together. Create error-free SQL deployment scripts to deploy data changes between your environments.

The differences between rows are highlited and you can view the data for each table you are comparing.
Screenshot: Command line options.

Work with the command line

Carry out any task using the command line tool. Automate scheduled tasks like comparisons and deployments for continuous integration.

Part of the Deployment Suite

Speed up database comparison and deployment tasks for shorter, more accurate release cycles with the Deployment Suite for Oracle.

Also contains Schema Compare for Oracle and Source Control for Oracle

Save 30% on the price of all three tools

Screenshot tour

Highlighted differences between rows

Differences between rows are highlighted and you can view the data for each table you're comparing.

Emphasis on rows with differences

Scroll through each difference and each record with a difference with increased visibility.

Pivoting comparison results

The pivot view rotates the data so that you can view the values for a record as a group, displayed vertically.

Selecting what data to deploy

Use Data Compare for Oracle to deploy table data changes.

Generating a deployment script

Create a deployment script to run manually, or have Data Compare for Oracle run the script for you.

What our customers are saying

“With Data Compare for Oracle, we can easily compare the data in two different database builds and generate the synchronization script. It's going to save at least an hour of development time each week – and stop me going grey so quickly!”

David Hart,
Senior Application Developer,
T2 Systems

Further information and support

Save 30% with the Deployment Suite for Oracle

Get all our Oracle tools at a 30% discount with the Deployment Suite for Oracle:

  • Data Compare for Oracle
  • Schema Compare for Oracle
  • Source Control for Oracle

Learn more

Try it free for 28 days

Start comparing Oracle tables today with a 28-day trial of Data Compare for Oracle.

Download free trial

Suggest new features

If you have suggestions for future versions, post it on our UserVoice page.

Report any bugs

If you've found a bug, report it on the Oracle tools forum so we can fix it.