Comparing and synchronizing Oracle database schemas
DBForge Compare Bundle for Oracle is a tool for comparing and synchronizing Oracle database schemas. It allows you to:
- Compare schemas between two Oracle databases and see the differences. - Synchronize the structure and data of one Oracle schema with another. - Add or drop tables, indexes, views, stored procedures, functions, packages, types, etc. to make the schemas equal. - Merge multiple schemas into one. - Convert the schema from one Oracle version to another.
Some main features of DBForge Compare Bundle for Oracle include: • Compare schemas at the table, index, view, procedure, function, package, type level. See the differences in a user-friendly comparison window. • Synchronize schemas automatically by applying the differences. Choose what objects and changes should be applied. • Add/drop objects easily with the help of context menus and wizards. • Merge multiple schemas into a single target schema. • Convert the schema from Oracle 9i to Oracle 12c, or between other Oracle versions. The tool generates the necessary ALTER statements. • Compare and synchronize data in Oracle tables (records, batches). • View the synchronization scripts in the SQL tab and execute/edit them. • Compare privileges, comments, storage parameters, etc. at the object level. • Compare and convert Oracle object dependencies (datatypes, tables that use some datatype, etc.). • Compare and convert Oracle triggers, indexes, constraints at the table level. • Resolve name clashes automatically during the schema merge operation. • And more... The tool provides a lot of other useful features for working with Oracle schemas.