We are upgrading from Windows Server 2003 / SQL Server 2005 / GP 9.0 to Windows Server 2012 / SQL Server 2012 / GP 2015.
I understand that I need to perform an interim upgrade to GP 2010 and then onwards to GP 2015. What I am trying to ascertain is whether I can upgrade SQL from 2005 to 2012 up front (while still using GP 9) and successfully upgrading throughout.
I know GP 9 and SQL 2012 are not officially supported, but I would like to know if anyone has any experience with this setup and encountered any major issues.
The tentative plan:
- Deploy a new Windows Server 2012 machine w/ SQL Server 2012.
- Migrate SQL 2005 -> SQL 2012. Point all of our existing Windows Server 2003 + client machines to this new database server.
- (the above setup would run in production for a short period of time)
- Install Dynamics GP 2010 on another new Windows Server 2012 machine (client install only). Use this client install to upgrade Dynamics GP 9 databases to Dynamics GP 2010.
- Install Dynamics GP 2015 on the same server as the prior Dynamics GP 2010 install. Upgrade Dynamics GP 2010 databases to Dynamics GP 2015.
We have a lot of customizations and reporting services reports. These will all be re-developed or upgraded/updated for Dynamics GP 2015 / SQL Server 2012 Reporting Services in advance of the actual upgrade so they're ready to go at that time. There is a lot of out of date customizations and reports that we plan to rationalize during the upgrade by just re-creating fresh in the new version, leaving behind anything no longer necessary.
*This post is locked for comments