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
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.
Comments
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.
I still have the problem after applying the latest patch version.
Thanks
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.