Schema Compare Sequence with different start with
Comparing a Sequence with a different start with value is always displayed as equal in the comparison-results.
Production:
CREATE SEQUENCE EXAMPLESEQ START WITH 61 INCREMENT BY 1;
Test:
CREATE SEQUENCE EXAMPLESEQ 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.
An Option to compare and synchronize the "start with" of the sequence would be fine!
-
Chrsitian commented
Could be added as "Ignore START WITH in Identity Columns" in schema comparison options