I have a sync group that syncs 4 tables from on-premises to azure.
the sync management page says "Good" next to each point (on-premises, hub & Azure DB)
If I query the tables in the hub, I see that the number of rows in each of the tables matches exactly the tables in the on-premesis DB.
If I query the Azure DB 2 of the tables have exactly the same number of rows as the hub & on-premises but 2 of the tables have 0 rows.
The sync is set up as bi-directional. One of the tables has a filter on one column.
Any clues how to "kick" the sync to push the data from the hub?
I've tried adding an extra "dummy" table to re-provision to no avail.
I've clicked sync a couple of times - again - nothing.....
try to do a dummy update on the data you want to sync...
eg. update tablex set col1=col1
btw, have you looked at the event viewer->application and services logs -> data sync service if there are any errors logged there when applying changes to the on-premise database?
- Navržen jako odpověď Veerendra Kumar 16. srpna 2012 16:00