dbForge Schema Compare for Oracle Features
What Oracle server versions are supported?
- Oracle 11g, 10g, and 9i databases
- Express Edition (Oracle XE) 11 R2, 10 databases
- Snapshots of schemas (of all Oracle versions listed above)
Supported schema objects
- Array type
- Cluster
- Database link
- DML trigger
- Function
- Java source
- Materialized view
- Materialized view log
- Object type
- Package
- Procedure
- Sequence
- Synonym
- Table
- Table type
- View
- XML schema
What else can be compared and synchronized?
- User comments on schema objects
- Per-object security permissions
PL/SQL code comparison features
- Ignore white spaces and comments in code
- Ignore differences in identifier and keyword case
- Compare wrapped and unwrapped PL/SQL objects
How can I analyze comparison results?
- Filter, group, and sort objects in results
- View DDL differences for each pair of objects
- Preview schema update script for each object
- Generate schema comparison report in Excel and HTML formats
Synchronization features
- Create accurate synchronization scripts
- Migrate any schema differences (individual, selected, or all)
- Dependency check to script objects in the correct order for updates
- Automatic resolving of synchronization issues
- Warnings on controversial points prior to synchronization
How can I automate my routine tasks?
- Save comparison project settings for future use
- Use command line interface for automatic routine synchronizations
Schema snapshots and version control integration
- Create schema snapshots for audit and roll-back purposes
- Automatically commit snapshots to version control system
- Compare previous versions of schema with current one (source control integration)
Other features
- Compare and synchronize multiple Oracle schemas
- Can work without Oracle client software
View the list of features regarding editions at the Editions
page.