Elastic Pool and SQL managed Instance in the same architecture

NP 1 Reputation point
2020-10-22T12:21:07.687+00:00

Hi,

Could you please advise on how we can show SQL MI and Azure elastic pool in the same Azure Architecture diagram?

SQL MI is shown under MI Subnet. How do we depict Azure elastic pool and how do we show the connectivity between MI and elastic pool. These two need to be connected because the databases in elastic pool will feed data into Azure Datawarehouse sitting in SQL MI.

Please could you share the network/Architecture diagram?

Regards,

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Navtej Singh Saini 4,216 Reputation points Microsoft Employee
    2020-10-28T19:33:11.163+00:00

    @NP

    The use of Azure Data Factory(ADF) can be used here where Azure SQL DB and Azure SQL MI are both Source and Sink in a ADF.

    Please go through these documents for further details regarding the same:

    1) ADF Copy Activity
    2) Azure SQL MI

    Hope this helps. Please get back to us for any questions.

    Thanks
    Navtej S

    35814-image.png