Help with an architecture design

George Javadian 0 Reputation points
2024-05-17T15:41:53.2933333+00:00

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?

Azure SQL Database
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Marco Zemp 235 Reputation points
    2024-05-20T07:49:23.3033333+00:00

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

    0 comments No comments

  2. George Javadian 0 Reputation points
    2024-05-20T15:59:01.8066667+00:00

    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.

    0 comments No comments

  3. Oury Ba-MSFT 17,156 Reputation points Microsoft Employee
    2024-05-21T16:18:23.3166667+00:00

    @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