Sage 300 Database on Azure SQL

SUGGESTED

Hi everyone. I'm hoping someone here can answer this, rather than having to jump into the support gauntlet.

I work for an IT firm and a client of ours is presently running Sage 300 on a server VM, connecting to an MS SQL database on another VM, which hosted databases for other software as well. Both in an on-prem data center. We are in the process of moving their infrastructure to Azure. I know we will need a VM for Sage 300, but I am wondering if it's possible to migrate the database to Azure SQL, rather than spin up a new VM for it? It would be a decent cost savings and we have been able to move the other application databases to that. However, we don't want to go out of support compliance with Sage so I want to make sure this is both possible and supported.

Thanks very much!

Parents Reply Children
  • 0 in reply to Nobho13

    There was an issue several years ago where long Azure SQL Server hostnames were a problem, and a more recent post (I can't find) complaining of poor performance due to latency between the Sage 300 Azure application VM and the Azure SQL service.  Considering it takes less than an hour to install a quick Sample data system, I *highly* recommend just going ahead and installing Sage 300 on your Azure VM (then take a snapshop for later before proceeding) and create SAMSYS, SAMINC, SAMLTD, PORTAL, STORE, VAULT in Azure SQL, link them to Sage 300, load up SAMINC, SAMSYS and SAMLTD, login as ADMIN and see what performance is like.  If you're not using the HTML5 Web Screens client/service then make sure you use the same access method users will use (AVD/RDS published app for example) for performance testing.  Maybe you can get a lot done on free Azure credits.  I think it will definitely be worth the investment of setting up this test environment and testing performance yourself and have some finance team staff take it for a spin.  If its slow in the base configuration then Production will be way too slow.  If its snappy with the sample deployment then it will be acceptable with the live data in there.  Take the guesswork outThumbsup

  • 0 in reply to Accsys Consulting AU

    When l saw that there are no clear responses, l also thought the best option will be to test it myself. Thank you .