allow tables with circular references to sync
SQL Data Sync still has some issues supporting tables with self-referencing Foreign Key (FK) relationships. Resetting the status to “under review”.
we really need this too
we have a few self-referencing tables for heirarchies like i think some other apps have
and we have a couple actual circular reference tables too
so without this circular reference support we cannot use sql data sync at all
James Backert commented
Right now I have a table that represents a hierarchy. None of the tables make a complete circle reference, but the table does have a foreign key to itself. This seems like the best way to establish a hierarchy and should be supported