Schema Compare Sequence with different start with

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
wcdevart3
Posts: 7
Joined: Tue 11 Aug 2015 10:24

Schema Compare Sequence with different start with

Post by wcdevart3 » Tue 11 Aug 2015 10:39

Comparing a Sequence with a different start with value is always displayed as equal in the comparison-results.

Production:
CREATE SEQUENCE EXAMPLE_SEQ START WITH 61 INCREMENT BY 1;
Test:
CREATE SEQUENCE EXAMPLE_SEQ START WITH 41 INCREMENT BY 1;

After moving the data for a table which uses the sequence from production to test the Test-Sequence-nextval will set wrong values for new rows, if the start with is not corrected.

Howto compare and synchronize the "start with" of the sequence?

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

Re: Schema Compare Sequence with different start with

Post by alexa » Wed 19 Aug 2015 11:23

Unfortunately, there is no such a possibility. However, you can add a suggestion on our UserVoice forum where other users can vote for it http://devart.uservoice.com/forums/1328 ... for-oracle

We collect and analyze the information from this forum in order to make a proper roadmap for future product releases.

Post Reply