Share via

How to avoid database comparison between on-prem and azure sql after database restore

Aparna Manoharan 20 Reputation points
Nov 13, 2024, 10:54 AM

We have existing Azure data sync setup (in dev ,test and prod) between on-prem and azure sql .

As part of data refresh activity, lower env (dev and test) db will be refreshed (delete and recreate db) with prod data along with data sync objects in both on-prem and azure sql.

How to resume existing azure data sync after refresh activity assuming both source and target has exact same data.?

Does this require any reconfiguration to sync metadata.?

We have 150+ tables and we would like resume the sync operation without comparing row by row.

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Vijayalaxmi Kattimani 415 Reputation points Microsoft Vendor
    Nov 14, 2024, 1:42 PM

    Hi @Aparna Manoharan,

    Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

    We would like to inform you that, If you are refreshing the lower environment databases with production data and want to resume the existing Azure Data Sync setup, you can follow these troubleshooting steps:

    1.Delete the existing sync group: Before you can resume the sync operation, you need to delete the existing sync group. You can do this by using the Azure portal or PowerShell.

    2.Create a new sync group: After deleting the existing sync group, you can create a new sync group with the same configuration as the previous sync group. You can do this by using the Azure portal or PowerShell.

    3.Initialize the sync: After creating the new sync group, you need to initialize the sync by running a full sync between the source and target databases. This will ensure that the data in the source and target databases is in sync and that the sync metadata is up to date.

    4.Resume the sync: After initializing the sync, you can resume the sync operation by running incremental syncs between the source and target databases. This will ensure that any changes made to the source or target databases are synchronized in real time.

    If this not help, If you have a support plan could you please file a support ticket for deeper investigation and do share the SR# with us? In case if you don't have a support plan please let us know here.

    I hope, This response will address your query and helped you to overcome on your challenges.

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.


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.