Deployment extension for Oracle SQL Developer
The Schema Compare and Data Compare extenions for Oracle SQL Developer offer Developers and DBAs powerful and intuitive GUI-based solutions in which to compare differences between databases and schemas and deploy changes. Deployment scripts are automatically generated and can be exported for review, executed through SQL Developer or run within the software.
Oracle Developers and DBAs use the Deployment Extension for:
- Faster deployment
Speed up your deployment process by automating key tasks such as the creation of error-free SQL scripts to update one database with the contents of another. - Better accuracy
See table records and schema displayed side-by-side with highlighted differences enabling you to troubleshoot and resolve errors caused by differences. - Keeping records of database changes
Generate interactive HTML reports containing all of your schema differences. XML and CSV reports are also available. - More time
The Deployment Suite for Oracle will free up your time and ensure faster, more accurate deployment.
Installation
- Use Oracle SQL Developer Check for Updates to install the extension (the Deployment Suite for Oracle installer is included).
What people say...
One word.... WOW!!!! Exactly what I'm looking for. With multiple developers possibly posting changes into a dev database, this allows me to generate a script to sync up and compare the two schemas. Works like a charm.
Al Drozd, Senior Application Developer, Hewlett Packard
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, APEX Evangelists, Oracle ACE Director
We plan to integrate Data Compare for Oracle in our nightly builds. At the moment, all our data related changes have to be scripted manually, which is error prone and not very productive. With Data Compare for Oracle, we can easily compare the data in two different database builds and generate the synchronization script. It's going save at least an hour of development time each week - and stop me going grey so quickly!
David Hart, Senior Application Developer, T2 Systems
Read more testimonials
