Thank you for your response Jo.
Yes we typically upgrade SQL and GP at the same time and we were planning to do it early next year. Our HR and Payroll departments have determined that we need the 2019 YE update to get the 2020 W4 changes. As you stated we could stay on 2016 and upgrade to the 2019 YE update for GP 2016 but that is still an upgrade for us. We have a great deal of internally developed dex customization and when we upgrade we would prefer going to the latest version. We have multiple test environments and have every business unit do a couple weeks of testing so upgrades consume a significant amount of resources. I was trying to see if anyone else was doing it help me get a better feel for the risk. I was, and still am, feeling like the risk is extremely. Donny and Jeff have strengthened my thoughts with their ideas in their responses but I still haven't heard of anyone in production on GP 2018 and SQL 2012.
We have the SQL 2019 upgrade project started but hardware will not arrive until next year so if we run GP (18.2) on SQL 2012 if won't be for long.
I have gotten to the point where I have tested GP (18.2) with the 2019 YE update on multiple installs with no issues so far. Working on testing our customizations now.
Thank you Jo and everyone else for your input!Rob
If you've found this thread useful, dive deeper into User Group community content by role