Dynamics GP 2018 is compatible with Azure SQL Managed Instance?

(0) Share

Report

Posted on by Vansh Kumar

Hi Everyone,

We are planning to migrate the SQL database to Azure SQL Managed Instance for one of our client.

Before starting the migration process we just need to confirm wheather Dynamics GP 2018 is compatible with Azure SQL Managed Instance or not?

We are not getting any conrete document from anywhere that confirm the query.

We have raised the ticket with MS support as well but they also do not have any concrete answer for this.

We checked multiple documents and we found the answer for Azure SQL but not for Azure SQL Managed Instance.

If anyone of you can check and let us know about this or aware of this please let me know and if you find any documentation please do share as well.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Vansh Kumar 5 on at

Like (0)

Report

Got the Reply from Microsoft Suport -

==========================================================

Microsoft Dynamics GP does not support using Windows Azure’s SQL Database feature that provides a database-as-a-service.

Since this hasn’t been tested, it would be considered an unsupported environment. I do have the following links to some forum and blog posts that do go into the setup of this type of environment, so it does look doable; however, it would still be an unsupported environment as it hasn’t been fully tested.

Dynamics GP does not work on Azure SQL cloud database. The name DYNAMICS is a reserved word on Azure SQL, therefore you would need to create the databases on-premise, using a system database name other than DYNAMICS. Once this is done, you will need to migrate the databases to the SQL Azure as GP Utilities cannot create them. The 'sa' account does not work SQL Azure, so this would be a major issue to sort out. Finally, Dynamics GP company databases (and the application) make several calls out to the system database. As of today, you cannot run a query against another database unless you create an Elastic Pool - this is something not supported by Dynamics GP, because, well, Dynamics GP does not support Azure SQL.

So, installing SQL Server onto an Azure VM where you can use an ODBC connection to connect to GP is going to be the ONLY supported environment.

Was this reply helpful? Yes No