Forum Discussion

Iron Contributor

Jan 15, 2018

Classic ASP and SQL server on Azure > Offline transactions

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...

Mike Jansen

Iron Contributor

Jan 15, 2018

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

Anthony Fear

Copper Contributor

Jan 17, 2018

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

Mike Jansen
Iron Contributor
Jan 18, 2018
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.
- Amine Eznaidi
  Copper Contributor
  Feb 15, 2018
  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...