Schema Compare Sequence with different start with
Posted: 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?
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?