We currently have an installation of GP10 SP2 and 2005 SQL server. We want to migrate to a new server and SQL2008R2.
We did a base DVD install and load SP2 in the new server. We get the message
We went online and find out SQL 2008R2 is not supported until SP5 is installed. So is it better for us to
1) Upgrade the existing production server to SP5
2) Upgrade the replacement server to SP5
3) Migrate the data from production to replacement
and if we do follow those steps, Do we have to rebuilt a client package for the current existing users ? Will they be able to log into the new server without us having to build a new client update? Or should we have to build a new client update package for the stations
Hi Kim,
Your steps above are reasonable. You don't need to issue a new install package - you just need to edit the ODBC's on each workstation to point to the new server.
I would complete steps in a Test enviornment first, including upgrading to SQL 2008R2 and make sure it works.
Ian.
Ian Stewart MVP - International support for Dynamics GP. Local knowledge, local timelines, local GP talent. Genesys Financial Systems (Europe) Microsoft Gold Certified Partner http://dynamicsgp.wordpress.com/
Keep in mind that the SP5 will need to be deployed on all client machines.
Regards,
Mohammad R. Daoud MVP-MCT
Have you seen the GP Excel Paste yet? http://di.jo/GPExcelPaste.aspx