Microsoft Dynamics GP 9 SP3 Upgrade Path To 2010 R2

I did a bit of searching and couldn’t find a specific declaration of the upgrade path from Microsoft Dynamics GP 9 SP3 to Microsoft Dynamics GP 2010 R2.

After reading around and trying to work out the correct path, I decided the likely upgrade path would be GP 9 SP3 > GP 10 SP5 > GP 2010 R2, but I would try GP 9 SP3 > GP 2010 R2 and see if it would work (although I was extremely skeptical) as this would save some time on the upgrades if it was possible.

I created a test environment containing SQL Server 2000 and SQL Server 2008 R2, and clients for GP 9 SP3, 10 SP5 and 2010 R2 (I expected to need the GP 10 client so I installed it now as GP 10 will not install if GP 2010 is present; Dexterity Shared Components 10 will not install if v11 is present) and then restored the GP 9 SP3 database into SQL 2008 R2.

When I ran GP Utilities for GP 2010 R2 I received, as expected, the following error;

There was a problem ascertaining product version information. Microsoft Dynamics Utilities will now exit. Please check the duinstall.log file for more information.

DUInstall.log (%ProgramFiles(x86)%\Microsoft Dynamics\GP2010\Data) contained the following error messages;



Failure encountered ON 21/10/2011 at 07:03:15 .  Error:  Product 0 does not support upgrading from version 9.0.310.

Failure encountered ON 21/10/2011 at 07:03:15 .  Error:  Product 949 does not support upgrading from version 9.0.294.

Failure encountered ON 21/10/2011 at 07:03:15 .  Error:  Product 1058 does not support upgrading from version 9.0.30.

Failure encountered ON 21/10/2011 at 07:03:15 .  Error:  Product 1493 does not support upgrading from version 9.0.278.

Failure encountered ON 21/10/2011 at 07:03:15 .  Error:  Product 1878 does not support upgrading from version 9.0.277.

Failure encountered ON 21/10/2011 at 07:03:15 .  Error:  Product 2277 does not support upgrading from version 9.0.287.

Failure encountered ON 21/10/2011 at 07:03:15 .  Error:  Product 2992 does not support upgrading from version 9.0.277.

Failure encountered ON 21/10/2011 at 07:03:15 .  Error:  Product 3830 does not support upgrading from version 9.0.33.

So, as I strongly suspected; GP 9 SP3 cannot be upgraded in one fell swoop to GP 2010 R2.

Well, this is why I installed the GP 10 SP5 client as well. I fired up this client, used Utilities to upgrade the database to 10 and then used GP 2010 R2’s Utilities to complete the upgrade. After which we had a fully working GP 2010 R2 environment.

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

PrintFriendly Email Linkedin Twitter Facebook

Related Posts
Microsoft Dynamics GP Upgrade Conversion Process Error
Missing Data Source When Installing Microsoft Dynamics GP 2010
Analytical Accounting Microsoft Dynamics GP 2018 Upgrade Error
Check Remittance Undefined Symbol Error When Upgrading to Microsoft Dynamics GP 2010
Installing Microsoft Dynamics GP 2010 R2 – Database Compatibility Issue
Microsoft Dynamics GP 2018 R2 and Year-End Upgrade Blog Series Schedule
Microsoft Dynamics GP 2010 Utilities: BCP Utility Error
Installing Microsoft Dynamics GP 2010 – Insufficient Privileges To Modify The VBA Project Error