database management - Schema Compare for Oracle

Release Notes: Updates in 1.5 New feature: Command line- You can now use the command line to compare and deploy your databases using a Schema Compare for Oracle project. Fixes: OC-350 (Performance improvements ...

Release Notes: v6.1.0 Updated Aug 8, 2023 Features Added support for time based Schedule objects. ...

Description: Schema Compare for Oracle automatically compares and synchronizes the schemas of Oracle databases. Use it to eliminate mistakes deploying database changes from dev, to test, to production ... and troubleshoot and fix errors caused by differences in database schemas. Schema Compare for Oracle allows you to compare and synchronize the schemas of Oracle databases in three simple steps: Select data sources, ... select objects to synchronize and run the Synchronization Wizard. Schema Compare for Oracle Compares and synchronizes the schemas of Oracle databases Automatically compare and synchronize the schemas ...

Release Notes: v6.0.23 Updated May 30, 2023 Features Added support for VALIDATE_CONVERSION function. Fixes Reorganized NOT NULL constraint handling to avoid scripting duplicate NOT NULL related constraints. Resolved performance regression regarding dependencies. v6.0.22 Updated Apr 18, 2023 Features Compatibility ...

Release Notes: PL/SQL objects could be detected as different when comparing a live database and a scripts folder. v5.7.17 Updated Jul 21, 2021 Fixes Procedures that call a proc with the same name in different schemas ... IncludeStorageTablespace and IncludeStoragePartitioning set. Fixed error when Ignore system partitions option is enabled and the database has subpartitions. Fixed issue where LOB partitions would be compared when ... Features Upgraded Devart Oracle database connector library (9.13.1127). Separated Tablespace and Partitioning options into two independent options. Added support for Jobs definitions. Added documentation ...

Release Notes: Updates in 5.4.1 Allows using Service Name for manual connection to Oracle databases. ...

Release Notes: additional information when you send an error report. Fixes Schema name provided as command line is not case sensitive (for default). Issue with populating tables from database version Oracle 18c3 or Oracle ... names" option enabled fixed. Problem with "Identity" columns which occurs for database versions higher than 12c2 fixed. Problem with wrong "logging" clause for partitions fixed. ... for columns that required it. Issue with deploying database objects without schema specified, which are deploys to user schema and not to mapped schema fixed. Problem with duplicated foreign key constraint ...

Compatibility: Supported Oracle versions Oracle 19c Oracle 18c Oracle 12c Oracle 11g Oracle 10g Oracle 9i Requirements Windows Server 2016 Windows 10 Windows 8 Windows Server 2012 R2 Windows Server 2012 Windows 7 Windows Server 2008 R2 Windows Server 2008 Windows Vista Windows Server 2003 Microsoft.NET Framework ...

Release Notes: deploying from script folders to database fixed. OC-977: Issue when Primary Key was dropped before Foreign Key when adding clause "DISABLE NOVALIDATE" to Primary Key fixed. OC-1003: Issue ...

Release Notes: Updates in 5.3.3 Oracle database connector library updated (Devart dotConnect for Oracle, ver 9.7). ...

Release Notes: Updates in 5.3.4 OC-1085: Issue with missing objects after population in conjunction with error ORA-00942 fixed. OC-1019: Issue when LOGGING keyword removed from script file fixed. ...

Release Notes: Updates in 5.3.2 OC-1026: Parsing NOCACHE clause fixed. OC-1073: Error "Object reference not set to an instance of an object" when is selected storage option "tablespaces and partitioning" fixed. OC-951: Altering organization index with "parallel" fixed. ...

Release Notes: Updates in 5.3.1 OC-989: Fix for object scripter generating quoted identifiers containing a comma separator. Fix for public synonyms- key value already exists. ...

Release Notes: Updates in 5.3.0 OC-1043, OC-1048, OC-1055, OC-1064, OC-1066, OC-1072, OC-1075, OC-1076, OC-1077, OC-1081: Multiple fixes and improvements to Ignore Rules functionality. OC-981: Issue with system-created indexes and altering them with "parallel" fixed. OC-982: Issue with grants ...

Release Notes: Enables "Ignore objects" functionality for all users. Ignore objects (previous "pre-filtering") functionality enabled for all users. ODC-402: Issue with accessing system tables without correct permissions was fixed. OC-996: Grant's issue prior to index creation was fixed ...

Release Notes: Adds "Frequent Updates" program. "Frequent Updates" program was added. OC-949: (related to OC-950 and OC-963) – support for storage options and columns in materialized view log was added. OC-926: Oracle 12C R2 is properly recognised now. OSC-591: "ENABLE" keyword to ...

Release Notes: ordering (live database case). Resolved directory type of privilege issue. ...

Release Notes: Updates in 4.0.7 No visible changes, just keeping the versions in sync. ...

Release Notes: Maintenance release includes bug fixes. Fixed problem that comparison with scripts folder ignores TABLESPACE parameter. Fixed error "Unable to cast object of type 'System.DBNull' to type 'System.String'". ...

Release Notes: Improves object population performance. Improved object population performance. Materialized View Log: Support parallel clause. Support identity columns for non-dba user. Added support for static data (an option to store table data in version control). Resolved issue when comparison was ignoring ...