 |
| ||||
dbForge Schema Compare for Oracle is a professional schema compare tool designed to make the comparison and synchronization process 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 further synchronization.
Here are some key features of "dbForge Schema Compare for Oracle":
Oracle Connectivity:
· Support of Oracle 11 R2 Express Edition, Oracle 11, 10, 9i, Oracle XE
· Comparison and synchronization of databases on different Oracle versions
· Comparison of snapshots
· Connection Manager for a full control of database connections
Database Structure Comparison:
· Quick and accurate comparison with Schema Comp arison wizard
· Comparison of Oracle database objects: tables, views, functions, procedures, packages, DML triggers, sequences, synonyms, user types (object types, collections types), materialized views, materialized view logs, XML schemas, database links, Java sources, clusters
· Comparison of several schemas at once
· Start page for quick access to latest comparison projects
· Swap button to swap Target and Source databases on Schema Comparison wizard
· Options for tables and script-based objects comparison
· Object filter to compare only required object types
· Custom schema mapping (one-to-one)
· Schema comparison reports generation
Analyzing Structure Differences and Synchronization:
· Clear display of schema differences in the grid
· DDL differences in the text comparer with multicolor highlights based on the difference type
· Aut omatic grouping of objects by their type
· Capability to manage groups of objects in the comparison document
· Convenient filtering and sorting of comparison results
· Objects exclusion from synchronization
· Saving and loading of comparison settings
· Detailed synchronization script plan
· Synchronization script preview for any separate schema object
· Automatically compiled list of objects to add to the synchronization based on object dependencies
· Options to customize the synchronization script output
· Warnings on possible data losses or errors during synchronization
· Asynchronous structure synchronization
· Database comparison and synchronization via command line
· Tracking database changes using a version control system
SQL Execution and Data Management:
· Execution of SQL scripts and queries
· D ata editor with in-place filtering, grouping, and sorting options
· Paginal data access for large result sets
· Graphical card view for data editor
· Large objects (LOB) editor
· Text search in data editor
· Data printing
· Ability to postpone sending of data updates to the server (Cached updates mode)
Clear User Interface:
· Customizable window layout
· Tool windows with 'auto-hide' and 'float' modes
· Multiple shortcut schemes with full shortcut customization
· Tabbed groups for documents
· Toolbars customization
Requirements:
· 2 GHz or higher processor
· 1024 MB RAM
· 35 MB of free hard disk space
· .NET Framework
Limitations:
· 30 days trial
What's New in This Release: [ read full changelog ]
· On opening Connection the ORA-00933 error is received (R14892)
· Error on displaying connection editor form is fixed (T16315)
· The Error on clicking MyDefaults in Schema Synchronization Wizard is fixed (R15446)
· SET ROLE statement is supported (T61603)
· Error occurring on the 'Paste As New Record' command execution is fixed (R8991)
· The 'Empty path name is not legal' error on clicking Synchronize in the Synchronization wizard is fixed (R16854)
· Notes for bookmarks in query results are added (T16548)
· The 'Index was out of range' error on closing document is fixed (T62858)
· Error on displaying results of several SELECT queries is fixed (T64570)
· Message displayed on generating argument file is changed (T16317)
· Error on opening window with subquery by foreign key is fixed (T63953)
· Ability to set service name in connection manager is added (T62012)
Via: dbForge Schema Compare for Oracle 2.0.161
