Drop foreign key before sync

wwang

Hi, we only want to sync data in a handful of tables between two databases. The problem is that another table (not included in the sync) has a foreign key reference on one of the tables that is going to be synchronized. Is there any way to handle drop and re-create this foreign key other than do it manually before data sync?

richardjm

There is an option in the Project Configuration screen...

Disable foreign keys

...which is on my default. If you are only comparing the one table there is a little trick to compare the table on which you want to drop the foreign key but include a WHERE clause something like '1=0' so that no rows are actually compared so no differences registered. However synchronizing it should spot the other table with the foreign key and drop it as you expect.

HTH