web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

SQL 2008 and V9 - Upgrade compatibility Question

(0) ShareShare
ReportReport
Posted on by 4

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

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    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 Profile Picture
    2,611 on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans