Resync Azure Sql Data

Question

Resync Azure Sql Data

Konark Grocers 1

We have had an accidental deletion of data from the Azure Sql Database, and when I try to Sync the Data, it is only Brining in new changes but the old data is no longer being synced. \

My Configuration is sync data from Local Sql Database to Azure Sql and the mechanism is HUB win.

Please let me know how I can Resync the data.

KalyanChanumolu-MSFT 8,361 Reputation points

2021-06-25T07:32:16.63+00:00

@Konark Grocers Welcome to Microsoft Q&A forums and thank you for your interest in Azure SQL.
How is the sync set up?
Your local SQL Server is the member database with a one-way sync to Azure SQL database as the Hub?
Or is the Azure SQL database another member of the same sync group?

Please elaborate your set up so we can better assist you.

1 answer

Your answer

KalyanChanumolu-MSFT 8,361 Reputation points

2021-06-25T07:32:16.63+00:00

@Konark Grocers Welcome to Microsoft Q&A forums and thank you for your interest in Azure SQL.
How is the sync set up?
Your local SQL Server is the member database with a one-way sync to Azure SQL database as the Hub?
Or is the Azure SQL database another member of the same sync group?

Please elaborate your set up so we can better assist you.

Answer 1

KalyanChanumolu-MSFT 8,361

@Konark Grocers We were able to reproduce this behavior. You have configured a one direction sync from on-premises SQL Server (Member database) to Azure SQL Database (Hub database) but deleted the records from the Hub.
Since this is a one direction sync, Azure SQL Datasync monitors the source (Member database) for changes and not the Hub.

To initialize the sync again and, remove the table from your existing sync group and add the table to another existing/new sync group.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.
And if you have further questions or issues, please let us know.

Konark Grocers 1 Reputation point

2021-07-01T21:30:59.903+00:00

Thank you for responding to my question. I

did recreate the Sync Group before posting this question. I am not understanding remove the table from existing sync group and adding to another sync group.

One other thing I would like to bring up, the table is being fed by multiple identical sources. So by removing the table, I am risk of losing other two feeds that are feeding the same table.

Sorry if i am not making sense.
KalyanChanumolu-MSFT 8,361 Reputation points

2021-07-02T05:15:40.687+00:00

@Konark Grocers Your table on Local SQL Server database is being fed from multiple sources and this data is being synchronized to Azure SQL Database (Hub)?
Please elaborate your set up.
Konark Grocers 1 Reputation point

2021-07-03T19:31:53.103+00:00

No. My Hub Database is fed by three local sql server databases. For Eg: Inventory table in Hub is being FED by three local sql servers. Currently One local sql server data is having sync issues.

Share via

Resync Azure Sql Data

1 answer

Your answer