x Want to participate? Join the group to interact
  • State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 26 replies
  • Answers 1 answer
  • Subscribers 99 subscribers
  • Views 3867 views
  • Users 0 members are here
Browse Forums
Announcements
270
topics
260
replies
Databases and Operating Systems
763
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
852
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
877
topics
3k
replies
Sage CRM for Sage 300
183
topics
414
replies
Gerry Corcoran

Sage 300 Database on Azure SQL

SUGGESTED
Posted By

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!

  • 0
    SUGGESTED

    Re-upping this post. We have a client doing the same thing in AWS - Sage App server with SQL SaaS. Asked Sage support, their response:

    "Sage 300 has only been tested, and therefore officially supported, when installed directly on a server i.e. in a hosted environment it must be installed on host VM. SQL as a Service has therefor not been tested, and is not officially supported, on AWS, Azure, or any other hosted platforms.

     It might work however the customer will have to test this themselves and will not be in a position to escalate any issues unless it can be replicated in an instance with SQL installed on a supported environment."

    My two cents - it does work, but harder to set up. It was the client Network Admin's job to copy over databases and sort out SQL user permissions : )
    Also don't have SSMS manual Tasks/ Backup which limits you to true Sage dumps.

*Community Hub is the new name for Sage City