Azure Data Sync in Multitenant Scenarion. RRS feed

  • Question

  • I have multitenat application where i am using the shared  schema . I have single table in which i am storing data from all the on perimise table. in th etable schema i have added a tenant id to differenceate. Now i want datasync to work as it should update the on perimise table for different client based on the tenant ID. I have more than 20 customer. schema of on perimise and azure database table is same.

    To make it more clear

    table T1 with column c1, c2 and tenant id is on aure database.

    and same table T1 with column c1, c2 and tenant id is on diferent on perimise database.

    so with azure datasync it should update the on- perimsie table based on tenant id.

    Tuesday, February 26, 2013 4:37 AM

All replies

  • you can define a sync group filtered by tenant id. 

    ie., Tenant1SyncGroup, Filter: TenantId=1

    Tuesday, February 26, 2013 10:54 AM
  • according you i have to cretae different sync group. where i can modify the condition.

    But as there can be miximum 5 sync group a database can belong. i have 25 on perimise database.

    can it not be possible with single sync group.

    Tuesday, February 26, 2013 11:08 AM