Violation of primary key constraint

bragus

I am receiving this error on a table I do not have selected for synchronization.

Version is 8.0.2.5

Can you help?

Thanks
Brendan

Brian Donahue

Hi Brendan,

I'd recommend applying the latest patch version, as it fixes a problem with schema modifications to tables that have not been selected for synchronization:

SDC-1025 SDC drops foreign keys from unsynchronized tables

Here is a link to the patch information:
http://www.red-gate.com/MessageBoard/vi ... php?t=9880

I hope this helps.

bragus

Hi Brian,

I still have the problem after applying the latest patch version.

Thanks
Brendan

Brian Donahue

Hi Brendan,

Does it cause any problems just to use the "drop primary keys..." option in the project options? That will disable the primary keys during the synchronization and put them back again afterwards.