295
Hi All,
Couple of things.
Does anyone know the official stance from Microsoft on support for Dynamics GP 2016 with the SQL database hosted in Azure SQL Database (PaaS). I can't see it listed on the Dynamics GP 2016 system requirements document.
Also, does anyone know if Dynamics GP works with the database hosted in Azure SQL Database? (regardless of whether this is supported or not)
Many thanks for taking the time to read this.
Gavin
*This post is locked for comments
Gavin,
This IS NOT Microsoft's official stance and by no means it represents anyone's view at Microsoft.
I have done a lift and shift of Dynamics GP to an Azure SQL Managed Instance and it works! You can read all about it in my 3-part series of articles on the subject:
Deploying Microsoft Dynamics GP on an Azure SQL Managed Instance - Part 1/3
Deploying Microsoft Dynamics GP on an Azure SQL Managed Instance - Part 2/3
Deploying Microsoft Dynamics GP on an Azure SQL Managed Instance - Part 3/3
In this 3-part series I looked at everything from the provisioning of the Managed Instance to what works and what did not work. I want to clarify that an Azure SQL Managed Instance is full SQL Server as a service (PaaS) and not the traditional Azure SQL Database version. Please give my articles a read and I will be happy to discuss any follow up questions you may have.
I'm a developer for Dynamics GP. Here is my experience. First, Azure SQL doesn't like USE statements. I don't know if it's my ignorance as I just started playing with Azure SQL or if its just a fact of their model design. That being said, it makes it difficult to have a model like GP where you have the DYNAMIC database, (or whatever you called it), and Company databases in the same application. I know I had to re-write a ton of my code to handle multiple database as separate connections instead of one connection and switching between databases with a USE statement.
GP native code does utilize Caching for data operations, so that does lend itself to having the data server away from the client software. But, I'm not aware of strong failure handling due to bad net activity. So I would worry about that. Changing timeouts may cut down on wait time for actual failures, but at the same time could bite you if it is simply a long data retrieval for the entire data set.
Anyway, just my thoughts.
Gavin,
If you're actually looking for a DR solution (or at least the start of... ), you could use SQL backup to Azure blobs.. but there are some limitation around this :
www.mssqltips.com/.../sql-server-managed-backups-to-azure
As you said, using a pure SAAS apps on SQL Azure may become an issue to keep full control over the DB instance.. whereas with a VM, you basically manage your server in the cloud and are responsible for everything.
Hi Béat,
Thanks very much for taking the time to reply.
I hadn't actually thought about the GP client side of things I was just curious to know if this platform is supported as its not on the system requirements document.
Now I've thought about it a little more I can't see how this could work as GP relies on the DEX_SESSION and DEX_LOCK objects in the TEMPDB and it also has the DYNAMICS and any additional company databases which would need to be hosted. I'm not sure how this would work with Azure SQL database, however I assume it wouldn't.
Thanks once again for replying.
Gavin
Hi Gavin,
Where would your GP 'fat' client be installed ? locally on your network ? I doubt this is going to work good.. it's about the same as trying to access your GP SQL server over the WAN thru a VPN connexion.. unless you have a least 100Mbs throughput, it's likely going to be painfully slow for your users and the risk of network interruptions is too big.. Keep in mind that GP is true client-server application with transactions and operations performed from the client side, which requires an always-on line to the SQL server.
Now you could setup GP on Azzure not as PaaS database acces, but truly setup GP in the cloud on your own VM and provide access to your users thru RDP with published remote apps.. Before going that route, you may want to consider existing GP hosted solution that will charge you a monthly fee per user and take care of all the server maintenance..
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (