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!
![](https://secure.gravatar.com/avatar/b913655853b41339b58fcccd81feb0eb?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Chrsitian commented
Could be added as "Ignore START WITH in Identity Columns" in schema comparison options