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 inconjunction with Source Control for Oracle
  • Deploy databases from source control
  • Automate deployment tasks using the command line for continuous integration

Screenshot tour

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, RostimaRead more reviews
  • Screenshot: comparing two Oracle schemas side-by-side.

    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.

  • Screenshot: deployment script to sync schemas.

    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.

  • Screenshot: source controlling oracle schema objects.

    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.

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