What are the challenges you face when working across database platforms? Take the survey

Compare but deploy without IDENTITY_INSERT

Hi, it seems for me that SQLDC doesnt allow to ignore Identity Columns  in deploy script-  am I missing some features? (dropping PK or reseeding are not an options for me). Is there a way to produce INSERT_INTO command not containing Identity Columns and their data (to rely on Identity Increment in target DB)



  • Options
    Alex BAlex B Posts: 1,146 Diamond 4
    Hi @db_crafter,

    There is an option to include (or not) identity columns in the comparison and I believe this is ticked by default (so you would need to deselect it):

    There is also an option to reseed the identity columns but you said this would not work for you.

    You can set both of these when setting up the comparison on the Options tab.

    I hope that helps!

    Kind regards,


    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.