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!
 Anonymous
    
 shared this idea
Anonymous
    
 shared this idea
      
    - 
       Chrsitian
    
 commented Chrsitian
    
 commentedCould be added as "Ignore START WITH in Identity Columns" in schema comparison options 
