Schema Compare for Oracle - Ignore START WITH in sequence
Posted: Wed 05 Aug 2020 11:55
When we compare between dev and prod databases we do not care about the next sequence number for identify columns, since we are never going to transfer data, we only want the schema structure to be equal.
Ignore START WITH in sequence does this, but only when the target number is larger (or smaller depending on increment being positive or negative). Is there a way to make the compare always ignore this part?
For new tables the next sequence number will be added to synchronization script.
For existing tables that only have mismatch on sequence number an update script will be added to the synchronization.
For new tables the sequence number should be ignored when creating the synchronisation script.
For existing tables with mismatched sequence number as the only difference should not get a script created at all.
Any suggestions would be appreciated.
Ignore START WITH in sequence does this, but only when the target number is larger (or smaller depending on increment being positive or negative). Is there a way to make the compare always ignore this part?
For new tables the next sequence number will be added to synchronization script.
For existing tables that only have mismatch on sequence number an update script will be added to the synchronization.
For new tables the sequence number should be ignored when creating the synchronisation script.
For existing tables with mismatched sequence number as the only difference should not get a script created at all.
Any suggestions would be appreciated.