Part of the Deployment Suite for Oracle

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
  • Automate deployment tasks using the command line for continuous integration

  • 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.

  • Source control your schemas

    Source Control for Oracle 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.

  • 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.

  • 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.

Red Gate's Schema Compare is by far the best schema comparison tool on the market. It now takes just 45 seconds for me to compare 6,000 objects in different instances of my database.
This used to take 45 minutes in Oracle SQL Developer!

David Cardona, Technical Services Manager, Rostima


What really impressed me was the speed of the comparison. Comparing two schemas is done really quickly, even with a couple of medium sized production schemas.

Alex Nuijten, Oracle ACE Director



The interface of Schema Compare for Oracle is very clean, it's easy to use and it gives me most features I'm searching for. There is even a SQL Developer plugin for Schema Compare for Oracle (search for Schema Compare for Oracle in the SQL Developer Plugin repository).

Dimitri Gielis, Oracle ACE Director



If you're looking for an easy to use, reasonably priced schema comparison tool for Oracle that allows you to fine tune the kinds of differences you're interested in seeing, then you need to take a look at Schema Compare for Oracle from Red Gate.

Bruce Armstrong, SimpleTalk



Red Gate's Schema Compare for Oracle accurately compared Peoplesoft Financials in 38 minutes. Embarcadero completed the same job in over 12 hours, and we simply couldn't get Toad's schema compare tool in their DBA suite to even finish the job, it would just error out.

Jim Findlay, Database Manager, Public School Retirement Systems of Missouri

Read more... Collapse

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