3

I need your suggestion for applying Federation in SQL AZURE. In one my recent project I already have an Azure database. In this project I have a big list of customers and each customer has another big set of registered users (more than 25000 because it's a medical system).

For that our job is to create a federation for each customer. So there customer data is stored in master DB and registered user data under each customer can be stored in a separate federation member.

Here my problem is how can I design a federation key because if I use customer Id as federation key then all the user in the first federation member should have same key. So it's not possible. If you have any idea then share that with me please

How can I solve this problem? Please help me.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Hope
  • 1,252
  • 4
  • 17
  • 35

1 Answers1

2

your question is a bit tricky. you want to federate by customer but you want you customer in the root db. if a user belongs to a customer, your user has some kind of a reference to the customer, then you can federate on the customer id.

if a user logins, dont they need access to the customer?

i suggest you have a look at this article:

Scale-First Approach to Database Design with Federations: Part 1 – Picking Federations and Picking the Federation Key

JuneT
  • 7,840
  • 2
  • 15
  • 14