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

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.

tomcruise
Posts: 1
Joined: Thu 28 Apr 2022 04:50

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

Post by tomcruise » Thu 28 Apr 2022 04:57

alexa wrote: Wed 05 Aug 2020 13:41 We will change the behavior of that option in one of the next product builds.
io games
Thank you,wordle website look forward to receiving the update soonest.

Post Reply