Options
Drop foreign key before sync
wwang
Posts: 2
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?
Comments
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
Project Manager
Red Gate Software Ltd