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

Ignore Identity Field

My source tables have identity fields. I need my target table to include the field but turn off the identity. I've tried checking "ignore indexes", "ignore identity seed and increment values", "ignore extended properties", etc. Nothing works. What am I missing?

Thanks.

Chris
ChrisClement
0

Comments

4 comments

Sort by
  • Daniel Handley
    Hi Chris

    If you want the target table to have the column but to remove the identity property you will have to ignore the column and create it yourself. This cannot be currently accomplished using any of the options in SQL Compare.

    Regards
    Dan
    Daniel Handley
    0
  • ChrisClement
    Thanks, Dan.
    ChrisClement
    0
  • ChrisClement
    How do I ignore a column?

    Thanks.

    Chris
    ChrisClement
    0
  • Daniel Handley
    Hi Chris

    Sorry you cannot ignore the column, or the identity property, with SQL Compare. If you want to use SQL Compare you will have to manually remove the identity value after the synchronisation.

    Regards
    Dan
    Daniel Handley
    0

Add comment

Please sign in to leave a comment.