CODEWITHSUNDEEP
azureazure-data-sync
sy-huss
sy-huss

Reputation: 193

Is it possible to set Primary keys in the HUB database in Azure Data Sync?

One of my tables in the HUB has a primary key that is causing records to be dropped in all the member databases. This Primary Key dynamically changes based on record updates.

I understand that Azure data sync uses these keys to track changes, but for the primary key that has dynamic data generated, it is dropping those records in the member database.

Does anyone have a solution?

Upvotes: 0

Views: 112

Answers (1)

Vitor Tomaz
Vitor Tomaz

Reputation: 81

In Data Sync, changing PK values is not supported, you need to delete the record and insert a new one.

Upvotes: 1

Related Questions