Handling GDPR while designing the data store

%3CLINGO-SUB%20id%3D%22lingo-sub-1598116%22%20slang%3D%22en-US%22%3EHandling%20GDPR%20while%20designing%20the%20data%20store%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1598116%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Champs%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20current%20design%2C%20we%20are%20using%20Azure%20VM's%20with%20SQL%20server%20and%20region%20is%20West%20US.%20But%20now%20I%20need%20to%20store%20the%20client%20data%20from%20Europe.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EApplication%20is%20pointing%20to%20the%20database.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20facing%20challenge%20to%20redesign%20the%20data%20store%20in%20SQL%20server%20with%20different%20instances%20and%20how%20to%20segregate%20client%20data%20based%20on%20country%20or%20region.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20guide%20me%20how%20to%20handle%20this%20challenge%20in%20SQL%20server.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWarm%20Regards%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi Champs,

 

In current design, we are using Azure VM's with SQL server and region is West US. But now I need to store the client data from Europe.

 

Application is pointing to the database.

 

I am facing challenge to redesign the data store in SQL server with different instances and how to segregate client data based on country or region.  

 

Please guide me how to handle this challenge in SQL server.

 

Warm Regards,

0 Replies