Red Gate logo

The fast way to compare and deploy Oracle schemas

See differences in schemas side-by-side and script up changes.

Download 28-day free trial

Database diff tool for Oracle schemas

  • Identify differences between your largest environments within minutes — smaller schemas take seconds to compare
  • Eliminate mistakes migrating database changes from dev, to test, to production
  • Compare multiple schemas
  • Compare schema objects with creation scripts — use in conjunction with Source Control for Oracle
  • Deploy databases from source control
  • Command line automation
  • Run Schema Compare for Oracle on your build server for continuous integration (with the SQL Automation Pack)

Screenshot tour

View schemas side-by-side

Drill down into the DDL for each object in your schema to see highlighted differences.

Filter by object, or type an object name to find it fast.

Compare databases, snapshots, and scripts folders. Easily find and fix errors in deployment.

Deploy schema updates

Automatically create error-free synchronization scripts to deploy only the schema changes you want.

Get deployment notifications about dependencies, truncations, and other issues.

Deploy using Schema Compare or your IDE, or save a SQL script to share with your team.

Work with the command line

Carry out any task using the command line tool.

Automate scheduled tasks like comparisons and deployments for continuous integration.

Output schemas to a scripts folder

Create scripts folders of your schemas.

Objects are exported as individual creation scripts and arranged in folders by type, so the structure of your database is maintained.

Watch fullscreen video

Source control your schemas

The perfect partner for Source Control for Oracle

Use Schema Compare for Oracle with Source Control for Oracle — which makes the process of checking database changes into SVN or TFS as simple as typing a comment.

See who modified the database and why, and access a history of every change.

Learn more about Source Control for Oracle

Source Control for Oracle

What our customers are saying

Case study

DRW Trading saves time with Schema Compare for Oracle

We speak to Michelle Malcher, DBA Team Lead at DRW Trading Group, about how Schema Compare for Oracle has ensured more reliable releases for DRW and saves her team time.

Read the case study (PDF)

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.