SQL 2008 and V9 - Upgrade compatibility Question

(0) Share

Report

Posted on by Bron

4,887

Okay - Client is running V90 SP4 (latest build 9.0.385) on SQL2000 server.

Server is old and out of physical memory.

We want to do a test upgrade to GP2010.

Client buys a new SQL server and installs SQL2008 R2.

I copy the V90 databases onto the new SQL 2008 Server and create a 32bit ODBC. I attempt to perform a client install (V90 sp4) on the new server and get the error message about sql 2008 not compatible.........I wasn't aware of compatibility issue......but I have now researched and realize V90 does not run on SQL2008.

My question is..........

If I use the existing GP client install on the old server (sql2000) - create new odbc connection to the SQL2008 server - can I perform/test the upgrade?

Or is my only alternative - create new SQL instance on SQL2000 server and perform test upgrade on SQL2000 and then move everything over to new server after upgrading to GP2010? This would require more hard drive space................client has 13 databases..........alternatives?

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: SQL 2008 and V9 - Upgrade compatibility Question

Can't seems to find any other options, you will need to upgrade on your current SQL 2000 installation to Dynamics GP 2010, then upgrade your databases to SQL 2008, follow Mariano article below on your upgrade path from GP 9.0 to GP 2010:

community.dynamics.com/.../microsoft-dynamics-gp-2010-update-path.aspx
Suggested answer

Hossam Fathy 2,597 on at

Like (0)

Report

Re: SQL 2008 and V9 - Upgrade compatibility Question

You need to Install GP10 SP5 if you will use SQL2008 SP2.