Master/Staging Azure Sql Server DB and Switching Downtime

Question

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

Answer 1

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