Deployment Suite for Oracle

See side-by-side differences in your schema objects and table data

The Deployment Suite for Oracle tools have been engineered on the back of Red Gate's 12 years in developing industry-standard tools for database professionals. Our expertise has resulted in a rich user interface which allows you to quickly and clearly see where objects are different across multiple instances of your database. It doesn't matter where your dev, test, and production environments are - they could be on premises, hosted in a data center, in the cloud, or a combination.

Screenshots: Diff two Oracle schemas - view objects

Screenshots: Diff two Oracle schemas - view table data

Comparing schema objects and configuration data across databases

Schema Compare for Oracle identifies any differences in your schema views, tables, triggers and packages and highlights them in a rich side-by-side comparison view of the creation scripts for your database objects. Data Compare for Oracle works in exactly the same way for configuration and look-up data.

Troubleshooting and resolving errors

You can drill down and look at each of your schema objects and table data side-by-side and clearly see where they are different from one environment to another. Once you've identified any errors, the tools quickly generate a flawless SQL script based on the exact objects and rows you want to fix. From here you can run the script through the UI or execute it through your IDE.

Better integration with your IDE

The Deployment Suite for Oracle has an extension for Oracle SQL Developer and a plug-in for PL/SQL Developer for better integration with your IDE.

Support for multiple Oracle database versions

• Oracle 9i, 10g & 11g (on premise and hosted)
• Oracle Cloud
• Amazon RDS for Oracle

Save money over buying the tools individually

• Deployment Suite for Oracle: from $695
• Schema Compare for Oracle: from $395
  Data Compare for Oracle: from $395
  Schema Doc for Oracle: from $95

What people say...

Schema Compare for Oracle made it possible for me to quickly and easily find the differences between our development and production databases, which had diverged over the course of development. The UI was so intuitive that there was no need to resort to documentation. I was able to download, install, and run within minutes and the problem was resolved that same day.

Jim Gregoric, Senior Software Engineer, Children's Hospital Boston