Forum Discussion
Classic ASP and SQL server on Azure > Offline transactions
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 ?
Sorry for the confusion. I want the SQL server to Azure as well.
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
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.
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...
