Schema Compare for Oracle - Ignore START WITH in sequence

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
retailrisk
Posts: 1
Joined: Wed 05 Aug 2020 11:34

Schema Compare for Oracle - Ignore START WITH in sequence

Post by retailrisk » 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.

alexa
Devart Team
Posts: 2889
Joined: Fri 24 Jun 2011 14:17

Re: Schema Compare for Oracle - Ignore START WITH in sequence

Post by alexa » Wed 05 Aug 2020 13:41

We will change the behavior of that option in one of the next product builds.

Post Reply