Master/Staging Azure Sql Server DB and Switching Downtime

Geeky Cool 21 Reputation points
2021-07-10T19:43:18.503+00:00

We have a requirement where we are loading data in staging DB (Azure Sql database) from On premise using ADF/SHIR . This staging DB will be used to push data in Master DB (Another Azure Sql database) . We want to ensure while this load goes from Stage to Master using ADF no one else can access master DB ( for example any other application, managed service ) , what are the possible strategies for to accomplish this ? We are also thinking to move Staging to Master load using ADF , please let us know if we have to take care of anything to maintain transactional integrity and how do we minimize downtime.

Thanks

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,983 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,231 Reputation points Microsoft Employee
    2021-07-13T00:33:10.807+00:00

    Hello @Geeky Cool ,
    Thanks for the ask and using the Microsoft Q&A platform .

    In the in premise world , we used to have a single user mode , but i dont think that exists in Azure SQl world . One thing which can be easy and simple should to remove the IP from the firewall setting . This way the server will block the IP's and i think it shoulkd work out .

    Please do let me know how it goes .
    Thanks
    Himanshu
    Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members