What is the GUID that gets created on Azure data sync objects

Aparna Manoharan 20

We have azure data sync setup for on-prem and azure sql db. When Initial trigger is started, there are Data sync tables, procedures and user types gets created.We notice the naming format for procedure is <table_name>_dss_bulkinsert<GUID>

What is the GUID here ? How does it this gets created? And How to rename this Guid ?

Thanks

1 answer

Kilian 345 Reputation points

2024-11-15T15:52:46.17+00:00

Hi Aparna,

How the GUID is Created

The GUID (Globally Unique Identifier) is automatically generated by Azure Data Sync when it creates the necessary objects (tables, procedures, user types) during the initial setup or synchronization process. This ensures that each object has a unique name, which is crucial for managing and tracking synchronization tasks.

Renaming the GUID

Renaming the GUID in these procedure names is not recommended or supported because it could disrupt the synchronization process. Azure Data Sync relies on these specific names to manage and execute sync operations correctly. Changing them manually could lead to errors or failures in data synchronization.

BR
Please sign in to rate this answer.
Aparna Manoharan 20 Reputation points

2024-11-15T16:36:06.9333333+00:00

Thanks @Kilian

We have azure data sync set up between on-prem and azure sql db.

As part of data refresh activity , both on-prem and azure sql db will restored (delete and recreate) from higher env

Is there a way to configure sync-group without doing row by row configuration assuming data is same in both on-prem and azure sql

Kilian 345 Reputation points

2024-11-18T07:50:12.0233333+00:00

You`re welcome @Aparna Manoharan !

I think you can configure your sync group to avoid row-by-row comparison after restoring both your on-premises and Azure SQL databases. Here are the steps to achieve this:

Backup Sync Metadata: Export sync metadata before refreshing.

Recreate Data Sync Objects: After restoring databases, recreate Sync Groups and Sync Members.

Reconfigure Sync Members: Delete and re-add Sync Members in the Azure Portal.

Manual Sync: Perform a manual sync to resume operations.

Please let me know if this helps

BR

Kilian 345 Reputation points

2024-11-18T07:54:03.8133333+00:00

You`re welcome @Aparna Manoharan !

I think you can configure your sync group to avoid row-by-row comparison after restoring both your on-premises and Azure SQL databases. Here are the steps to achieve this:

Backup Sync Metadata: Export sync metadata before refreshing.

Recreate Data Sync Objects: After restoring databases, recreate Sync Groups and Sync Members.

Reconfigure Sync Members: Delete and re-add Sync Members in the Azure Portal.

Manual Sync: Perform a manual sync to resume operations.

Please let me know if this helps

BR

Aparna Manoharan 20 Reputation points

2024-11-18T07:56:10.02+00:00

How to back up sync metadata?

Kilian 345 Reputation points

2024-11-18T08:01:47.9466667+00:00

Identify the Sync Metadata Database

Export the Metadata Database via Azure Portal

Backup Using SQL Server Management Studio (SSMS)

Automate Backup with PowerShell

Kilian 345 Reputation points

2024-11-18T08:21:51.9866667+00:00

Export via Azure Portal:

Go to your SQL Database.

Select Export under Operations.

Provide storage details and start the export.

Use SSMS:

Connect to Azure SQL with SSMS.

Right-click the metadata database > Tasks > Back Up.

Automate with PowerShell

Aparna Manoharan 20 Reputation points

2024-11-18T10:01:37.68+00:00

We are not making changes to metadatabase. Why is it neccessary to export metadatabse .? We are only restoring(delete and recreate) member database's

Every time database is restored . sync group and sync members are created again.

Which creates new GUID and enforces row by row comparison.

Kilian 345 Reputation points

2024-11-18T10:50:33.9+00:00

If you’re not making changes to the metadata database and only restoring the member databases, you can avoid row-by-row comparison by following these steps:

Backup Sync Metadata: This step ensures you have a reference, but since you’re not changing the metadata database, you can skip this if it’s already stable.

Recreate Sync Members:

After restoring the member databases, delete and re-add the Sync Members in the Azure Portal. This step is crucial to re-establish the link between the Sync Group and the new database instances.

Manual Sync:

Perform a manual sync to ensure the sync process recognizes the schema and data match, avoiding extensive row-by-row comparison.

Aparna Manoharan 20 Reputation points

2024-11-18T13:38:42.8833333+00:00

When restoring member database , the entire sync-group gets deleted, which enforces to create new sync setup and row by row comparison is not avoided

Mahesh Kurva 890 Reputation points Microsoft Vendor

2024-11-19T20:09:34.91+00:00

Hi @Aparna Manoharan,

When you restore the member database, the entire sync group gets deleted and a new sync setup is created. This will enforce row-by-row comparison and synchronization. Unfortunately, there is no way to avoid this as the sync group and sync members are tied to the specific database instance and its unique identifier (GUID). When you restore the database, the GUID changes, and the sync group and sync members are no longer valid. Therefore, you will need to recreate the sync group and sync members and perform row-by-row comparison and synchronization.

Aparna Manoharan 20 Reputation points

2024-11-20T14:55:21.7366667+00:00

Hi @Mahesh Kurva

Is there any other work around to restore member database and avoid row-by-row comparison?

Mahesh Kurva 890 Reputation points Microsoft Vendor

2024-11-20T19:20:59.9633333+00:00

Hi @Aparna Manoharan,

Is there any other work around to restore member database and avoid row-by-row comparison?You might explore other data synchronization solutions that offer more flexibility and control over the synchronization process.

While these steps won’t completely eliminate the need for row-by-row comparison, they can help manage the process more efficiently.

For more information, please refer the document: https://techcommunity.microsoft.com/blog/fasttrackforazureblog/relational-data-synchronization-between-environments/4066739

I hope this information helps. Please do let us know if you have any further queries.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

What is the GUID that gets created on Azure data sync objects

1 answer

Your answer