How can we help you today? How can we help you today?

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)

db_crafter
0

Comments

1 comment

Sort by
  • Alex B
    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,

    Alex

    Alex B
    0

Add comment

Please sign in to leave a comment.