Azure Dynamics GP 2018 Installation SQL Server Troubleshooting

Microsoft Dynamics GP: Running System and Company Databases on Azure SQL - Part 2

From the archive. This post dates from the blog’s Dynamics GP and early Power Platform era. Products and screenshots may have changed since it was written, and some of its links (PartnerSource and CustomerSource pages, legacy Maximum Global Business downloads, and other retired sites among them) may have been archived or may no longer be available.
In Part 1 of this series, I showed how to create the Azure SQL server and initialize the shell databases needed to move a set of existing Microsoft Dynamics GP on-premise databases.



This video shows the first set of problems you will run into, in order to support Microsoft Dynamics GP on Azure SQL, namely:
  • You cannot deploy CLR assemblies on Azure SQL. Both the Workflow and Document Attach architectures rely on CLR assemblies to facilitate some of the functions they perform. 
  • Some schema objects are blocked from creation on Azure due to references to system objects that are only available to the on-premise version of SQL Server. 
  • Some SQL JOIN operations can create significant performance bottlenecks and would need to be refactored to improve performance.
Part 3 of this video will allow you to see how far we got with this experiment.

Until next post,

MG.-
Mariano Gomez, MVP
Azure Dynamics GP 2018 Installation SQL Server Troubleshooting

Comments

Post a Comment
Microsoft MVP Alumni