making users comfortable when their data sits on azure

Question

hi we might want one of our operation data stores (ODS) to sit on an azure sql database. ODS's aren't normally mission critical but they can play an important role in running day to day business. So how do you tell your user not to worry that if the internet goes down, their azure sourced reporting app will as well?

Answer 1

In countries like mine, sometimes you get Inernet outages by specific Internet providers and sometimes power outages occur. You can continue to have your main ODS database (let's call it hub database) on the Azure cloud as an Azure SQL database. You can also have a local SQL Server instance (on-premises) that has a copy of the Azure SQL Database (let's call that database a member database). You can keep the hub and member database in sync (one-direction or bi-directional sync, as you decide) to keep them in sync using a free tool named SQL Data Sync.

In case of a power outage or Internet outage, reports can try to connect to Azure SQL database (hub database) and will fail, then they can try to connect to the on-premise (member) database.