dbForge Compare Bundle for Oracle contains two separate tools, dbForge Schema Compare for Oracle and dbForge Data Compare for Oracle. dbForge Schema Compare for Oracle is a tool that makes the comparison and synchronization of schemas quick and easy. It can compare multiple database schemas at once, completes the comparison process in seconds, provides a clear grid to analyze differences and generates an update script for accurate synchronization. dbForge Data Compare for Oracle is a powerful, fast, and easy tool for comparing and synchronizing Oracle databases. It helps you quickly compare data in tables, find the differences at a glance, and generate a script to effortlessly synchronize data. Database professionals use dbForge Data Compare for Oracle to save time with automatic table data comparing and synchronization, analyze data differences and generate reports, quickly reconcile two databases that are out of sync, copy look-up data from development databases to production, generate SQL*Plus-compatible synchronization scripts and more.
Features
dbForge Data Compare for Oracle Key Features
- Supports Oracle versions: 11g, 10g, 9i, 8i, 7.3, Oracle XE
- Compares tables, views and materialized views
- Compares data with different structures
- Able to compare multiple schemas at once
- Command line interface for scheduled operations
- Synchronizes data in LOB and BFILE columns
- Generates data comparison reports
- WHERE filter for extra large tables or custom data comparison
- Can work without an Oracle client
- Generates SQL*Plus-compatible synchronization scripts
- Can save data comparison settings for the next usage
- Has a convenient UI
dbForge Schema Compare for Oracle Features
dbForge Schema Compare for Oracle supports the most-demanded object types of Oracle databases used during the database development process:
- Tables
- Views
- Synonyms
- Sequences
- Procedures
- Functions
- Packages
- DML Triggers
- Array Types
- Object Types
- Table Types
- XML Schemas
- Materialized views
- Materialized view logs
- Database links
dbForge Schema Compare for Oracle works with databases where other tools freeze and fail. Numerous stress tests performed on different schemas of live databases used in actual businesses prove the ability of the tool to work with any Oracle schema. So if you work with complex databases, you can rely on dbForge Schema Compare for Oracle to perform all tasks related to schema comparison and synchronization.
Features list:
- Supports Oracle versions: 11g, 10g, 9i, Oracle XE
- Compares wide range of object types in Oracle databases
- High performance of comparison
- Ability to work with multiple schemas at once
- Rich comparison options
- Generates schema comparison reports
- Can work without an Oracle client
- Customizable synchronization via wizard
- Generates SQL*Plus-compatible synchronization scripts
- Can save schema comparison settings for the next usage
Standard Edition includes:
- Major schema objects comparison and synchronization
- Rich comparison options
- Schema comparison reports in Excel and HTML formats
- Schema snapshot generation and comparison
The Professional Edition includes everything in the Standard Edition plus:
- Cluster objects support
- Java source objects support
- Wrapped PL/SQL objects: compare and sync
- Permissions on schema objects: compare and sync
- Integration with version control systems
- Command line interface
About Devart (formerly Core Lab)
Devart is a leading company working in the database connectivity area. We offer well-known native VCL/CLX components and dbExpress drivers for direct access to Oracle, MS SQL Server and MySQL. Provide advanced data access solutions for the Microsoft .NET Framework - ADO.NET data providers for native connectivity to Oracle, MySQL, and PostgreSQL database servers. Core Lab is also a vendor of powerful database tools designed to automate and simplify database development process.
