Help with an architecture design

Question

Hello,

We have a European customer who wants their data to be located in Europe. We also want to upgrade our current on-prem SQL Server to an Azure Managed Instance (Azure SQL Database is out of scope). Our main database is located in the US, and we need to consolidate the European customer's data into this main database without using database sharding to avoid additional application work. Can you please recommend an approach to achieve this?

Answer 1

You will need to create a database resource in a European region to ensure that the data stays in Europe.

Answer 2

Thank you Marco. i was thinking to try and use Distributed AG setup between regions and then create bi-directional replication to sync data between databases in 2 regions. This is for Azure Managed instance. But i am not sure if this is the right approach.

Answer 3

@George Javadian Thank you for reaching out.

I addition to Marco Zemp, you can try the database copy and move.

Please see the following doc for more detailed information Copy or move a database - Azure SQL Managed Instance

Moving or copying a database is useful when you want to:

• Manage database growth and performance requirements.
• Balance workloads across multiple managed instances.
• Move databases to an instance with more available resources to handle the workload.
• Consolidate multiple databases from several instances.
• Create database parity between dev, test, and production environments.

Please let us know if you have additional queries or need more clarification.

Regards,

Oury