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

Anthony Fear

Copper Contributor

Jan 15, 2018

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 ?

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.