3 Replies Latest reply on Jul 26, 2017 7:30 AM by Peter de Vaal

    Database Diff enhancement proposal: Compare objects with system generated names on contents

    Peter de Vaal

      The Database Diff tool in SQLDev is very helpful in finding differences between schemas (e.g. between Dev and Test). It has the option to compare constraints only on their definition and ignore name differences. This is very helpful when having in-line constraint definitions without a name, because these get a system generated name which differs in each schema.

      However, system generated names are not only limited to constraints. Just 2 other examples are the sequence name of Identity columns and the names of IOT Overflow tables.

      Currently these always appear as differences on a Database Diff run.

      It would be nice to have the option to compare all such objects on definition and not on name.