I've got an error that does not make sense - as it really is NOT a circular reference - but a parent child relationship only
Cannot deploy the sync group because there is a circular foreign key dependency between the tables [dbo].[Invoices] and [dbo].[Customers].
Code: WebUx_CreateSyncGroup_CircularReference
Tracing Id: c5f3109e-eaf3-4646-830c-b45d3ff48cca
Why am I getting this message?
When will data sync be fixed to allow for circular references? Redgate SQL Data Compare handles circular references fine.
UPDATE:
Just found that though the error displays the wrong table names we do have two kinds of circular references - again RedGate had no trouble handing them but Data Sync apparently does.
Ran the script at http://blogs.msdn.com/b/sqlazure/archive/2010/07/01/10033575.aspx and found two kinds
1. self-referencing tables - for heirachies - but it says here http://blogs.msdn.com/b/windowsazure/archive/2012/01/26/announcing-sql-azure-data-sync-preview-refresh.aspx that
"Synchronization of self-referencing tables is now supported" - is that true?
2. actual circular reference - parent -> child -> parent - wonder if i remove the foreign key reference if this will work
It says here that they are "under review" for fixing the circular reference issue
http://www.mygreatwindowsazureidea.com/forums/169922-data-management-sql-data-sync/suggestions/2330678-allow-tables-with-circular-references-to-sync
but i don't see any recent updates on this