Forum Discussion

Mike Jansen's avatar
Mike Jansen
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 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 

5 Replies

  • Anthony Fear's avatar
    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's avatar
      Mike Jansen
      Iron Contributor
      Jan 15, 2018

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

      • Anthony Fear's avatar
        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

         

         

Resources