RE: SQL 2019 Compatibility with GP 2018 R2
You don't want them to do this for a few reasons...
- SQL 2019 is still in CTP (Community Technology Preview) - Thus not even released officially - Anticipated April 2019?;
- Dynamics 2018R2 doesn't list SQL 2019 as a supported SQL Server - This means:
- There could be SQL features from supported versions (SQL 2014 + ) that may not exist in SQL2019;
- If you do a work around to make it run on SQL 2019, when you go to apply any update / patch then the Dynamics GP Upgrade WILL FAIL;
- Have any of your 3rd party products tested it and approved support on SQL 2019? - I would not think so, since SQL 2019, is not official;
I do understand why some would want to move to the newest and minimize costs in the future.
The main NEW features in SQL 2019 are cool and exciting, but from a Dynamics GP perspective have NO affect.
Moving to SQL2017, I would highly recommend.
It has many new features you could take advantage of outside of the Dynamics GP program, but again, Dynamics GP and thus the 3rd party products still need to make the product work with the lowest denominator, which is SQL2014.
Thus, the newest SQL features that would be built-in to Dynamics GP 2018R2 are the newest features that are in SQL2014.
I hope this helps and gives you the information to pass to your customer....