dbForge Schema Compare for Oracle Features
- Schema Objects Support
- With dbForge Schema Compare for Oracle, you can compare and synchronize the following schema objects:
- Array type
- Cluster
- Database link
- DML trigger
- Function
- Java source
- Materialized view
- Materialized view log
- Object type
- Materialized view log
- Object type
- Package
- Synonym
- Table
- Table type
- View
- XML schema
- Package
- Procedure
- Sequence
- Rich Schema Comparison and Synchronization Options
- User comments on schema objects.
- Per-object security permissions.
- Multiple Oracle schemas.
- Ignore white spaces and comments in code.
- Ignore differences in identifier and keyword case.
- Compare wrapped and unwrapped PL/SQL objects.
- Comparison Results Analysis
- 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.
- Schema Synchronization
- Multiple ways to synchronize schemas.
- 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.
- Routine Tasks Automation
- Save comparison project settings for future use.
- Use command line interface for automatic routine synchronizations.
- Code formatting.
- Schema export and import.
- Schema Snapshots and Version Control Integration
- Schema snapshot generation.
- Schema snapshot generation through the command line.
- Integration with TFS and SVN.
Standard Edition includes:
- Major schema objects comparison and synchronization.
- Start page with recent comparison projects.
- Schema comparison projects (saving schema comparison settings for the next usage).
- Rich comparison options.
- Cluster objects support.
- Java source objects support.
- Schema comparison reports in Excel and HTML formats.
- PL/SQL code completion.
- PL/SQL code formatter.
- Schema snapshot generation and comparison.
- Restore last opened documents.
- Connection coloring and Document categories.
- OS authentication.
- Work without an Oracle client.
- Query execution pane.
- Schema export and import.
The Professional Edition includes everything in the Standard Edition plus:
- Wrapped PL/SQL objects: compare and sync.
- Permissions on schema objects: compare and sync.
- Integration with version control systems.
- Command-line interface for schema comparison and synchronization.
- Formatting code through the command line.