Data Sync is missing records between On-Premises DB and Azure SQL DB

Cccccche 1 Reputation point
2020-08-28T14:45:46.78+00:00

Hi,

I have a data sync group on azure, which is allow me sync on-premised database's data to Azure SQL db. The Direction is Bi-directional, the conflict resolution is Hub Win. Now I have a problem: the azure db is missing 101 records from On-premised DB, I can't find the records in hub db neither. There is no error log related to this issue in the sync group logs, I checked the logs of local data sync agent, no error log related to this issue neither.

I followed this tread to manually insert the missing records to On-Premised db's tracking table. Which didn't work for my issue. Is there any suggest?

Thanks,

Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Cccccche 1 Reputation point
    2020-08-28T18:01:51.163+00:00

    Solved it.
    Below is the solution:

    1. Remove the table from sync group and do a sync. After this, you will see the tracking table is dropped from your hub DB and member Azure DB.
    2. Delete the record from missing data tables. In my case, my hub db and member Azure db is missing data, so I cleared the data of these two db.
    3. Start two new sync action(I started twice since the first sync action only synced my on-premised data to hub db.)

    Hope it will solve your problem.

    Thanks and have a good day :)

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.