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?
Schema Compare Sequence with different start with
Re: Schema Compare Sequence with different start with
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.
We collect and analyze the information from this forum in order to make a proper roadmap for future product releases.