Monday, February 26, 2018

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

In Part 2 of this series, I showed the data migration process for the Microsoft Dynamics GP system database. I also provided a few reasons why the Azure SQL platform is not supported. This vlog article will skim through the migration process for the company database and will examine more reasons why Azure SQL is not a supported configuration.



In this video I also examine other topics like the Azure SQL Query Editor which is currently in preview mode, and vertical elastic queries.

Until next post,

MG.-
Mariano Gomez, MVP

Friday, February 23, 2018

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

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

Friday, February 16, 2018

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

Hi all,

Before you get too excited, please know that there is no immediate plans for Microsoft to support Dynamics GP on Azure SQL. This vlog is rather an attempt to demystify some Community forum claims to his effect, but rather than simply saying "It doesn't work!", what I want to do is walk through the motions of provisioning the Azure databases, configuring the SQL Server, defining the elastic pool container, migrating the databases, and attempting to run Microsoft Dynamics GP and GP Utilities, while highlighting the current limitations preventing this configuration from working.




For ease of consumption, I have divided this vlog in two parts. Please enjoy part 1. In part 2, we will work on migrating the databases and getting GP connected to them. If nothing else, you would have learned how easy it is to get Azure SQL up and running :)

Until next post,

MG.-
Mariano Gomez, MVP

Friday, February 9, 2018

How to Manually Replace the Web Client SSL Certificates

I finally managed to get to this video! Every so often I come across Community forum posts requesting instructions on how to replace an expired certificate being used with the Microsoft Dynamics GP web client. The traditional response has always been to uninstall and reinstall the web client after replacing the certificate in IIS (single-machine installation), or to repair the installation (custom install). I frankly find those two processes a bit cumbersome and prone to errors, since system administrators often need to remember steps and entries that they may not even have initiated themselves.




The procedures I outline in this video make use of the netsh command prompt utility to accomplish this and I intend to soon publish a PowerShell script that would automate the entire process altogether. For now, enjoy this video and don't forget to provide your feedback.

Until next post,

MG.-
Mariano Gomez, MVP