I am using sync framework to sync sql 2016 to 2014
I have a connecting table which contains only 2 columns:
Table A: ID, Name
Table B: ID, Name
Table C: A_ID, B_ID
When i try to sync table C it goes into infinite loop and in the profiler i see this query running non stop:
exec [C_selectrow] @P_1=1,@P_2=1,@sync_scope_local_id=1,@sync_scope_restore_count=0
I found a workaround and added a dummy column with no data to table C (nvarchar(1) column) which solved the problem