I have two databases one is onpremise and other is on Sql Azure and i have create
a sync group that synchronize a table from on premise to azure as bidirectional sync
that table has 7 crore rows and the sync run approx 8 to 9 hours and at random my table
gets lock and i am not able to select any row from that table.
plz suggest me why dedlock occur and how to prevent this lock.
Whats going worng is there any other way to synchrinize my table from onpremise to azure database.
Thanks!!