Classic ASP and SQL server on Azure > Offline transactions

[Mike Jansen]

I have this classic ASP application (ASP/javascript/css/html) working with SQL server which I want to move to AZURE. I already did a proof of concept which worked fine. 

But is our business case it can be possible that we do not have an internet connection sometime. I do want to user to have the possibility to enter data (which must be cached and will be send to SQL server when the internet connection is available again).

I my scenario what solution can be advised?

Thanks, Mike 

[#2]

If I understand you correctly, you want to move the APP to Azure, but keep the SQL on premise ? 
Couldn't you use Azure SQL instead ? and get rid of the on premise SQL server all together ?

[#3]

Sorry for the confusion. I want the SQL server to Azure as well.

[#4]

if it's a mobile app, you could use the Offline data sync feature.

https://docs.microsoft.com/en-us/azure/app-service-mobile/app-service-mobile-offline-data-sync

If it's a desktop app, perhaps something like SQLlite could be used ?

https://www.sqlite.org/whentouse.html

[#5]

It's not a mobile app. Just a webapplication which, sometimes, is used on a tablet in places where Internet can be poor/none. I do want the user to be able to enter data, which can be processed when internet is available again.

[#6]

Could you explain how the app works now with SQL onprem? What is the version? Describe the whole process. If you decide to go webapp and SQL IAAS: it is the same process but without any knowledge of the network\architecture: i can only speculate...