Compare but deploy without IDENTITY_INSERT
db_crafter
Posts: 1 New member
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)
Tagged:
Answers
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
Have you visited our Help Center?