I run data compare on 2 DB’s that are idetical at level of metadata but different in datas.
These are the settings of dialog :
As you can see I flag checkbox of Drop/create foreign keys.
After comparison I run the update from source to target and I obtain this error message :
I try to translate the error message for you :
– Foreign key ‘FOGLIO_LAVORO_fk3_STO_FOGLIO_VIAGGIO’ of the table ‘STO_FOGLIO_VIAGGIO’ refers to the constraint ‘PK__ANAGRAFICA_ALBER__1CF15040’ . Impossible delete the constraint. See previous errors. –
Obviously the synchronization doesn’t works correctly.
Why this ? I set to drop the foreign key and re-create it in my settings …
I stay tune for your consideration.
Best regards, 7