Help Creating Azure Hosting for a SQLServer ERP Database

Hi Eric Stevens,

you’re looking to set up Azure hosting for your SQL Server ERP database, and you’ve got a couple of paths to choose from

Azure Virtual Machine with SQL Server: This option would mean you deploy a VM and install SQL Server on it. Since you have licenses from Infor for the SQL Server, you can definitely use those on an Azure VM. This gives you control over your SQL environment and configuration, but you’ll need to manage the VM as well (like updates and backups).

Azure SQL Database (without a VM): This is a PaaS option where you can host your SQL database directly in Azure without needing the underlying infrastructure (the VM). It simplifies management because Azure takes care of things like patching, backups, and high availability. However, there might be limitations if your ERP software requires certain SQL Server features that are only available in the full SQL Server versions running on a VM.

Note:

• Since your database size is under 5 GB, Azure SQL Database could be a cost-effective choice.
• Check whether your ERP software, Visual Manufacturing by Infor, has any specific requirements or recommendations regarding how to host their databases.
• Remember to consider your team’s capacity to manage a virtual machine if you go that route.

Steps to Proceed:

If you decide on the Azure VM route:

• You will need to create a VM in the Azure portal and select a SQL Server image.
• Install SQL Server and enter your licensing information.
• Ensure you have the right size and specifications for your VM based on the software requirements.

If you prefer Azure SQL Database:

• You can create an Azure SQL Server and select the appropriate database size and performance tier.
• Ensure it meets the compatibility requirements for your ERP system.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.