Ignore Identity Field

ChrisClement

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

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

ChrisClement

Thanks, Dan.

ChrisClement

How do I ignore a column?

Thanks.

Chris

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