Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / What is the migration ...
Microsoft Dynamics GP (Archived)

What is the migration path from Pervasive SQL to SQL 2005?

(0) ShareShare
ReportReport
Posted on by Tricia 325

Hi all,

I have a client that is currently on GP7 Pervasive SQL and I have to upgrade them to Dynamics GP10 on SQL 2005.

I have found the migration path for GP which is:

7.0 Pervasive to 7.5 Pervasive to 7.5 MSSQL to 9.0 MSSQL to 10 MSSQLor 7.0 Pervasive to 7.5 Pervasive to 7.5 MSSQL to 8.0 MSSQL to 9.0 MSSQL to 10 MSSQLOr

7.0 Pervasive to 7.5 Pervasive to 7.5 MSSQL to 8.0 MSSQL 2000 SP5 to 10 MSSQL

 

But  I am assuming I can't go straight to SQL2005, so I would like to find out at what point would I upgrade from SQL 2000 to SQL 2005 on either of these paths? RegardsTricia Rennie

 

*This post is locked for comments

  • Tricia Profile Picture
    Tricia 325 on at
    Re: Re: What is the migration path from Pervasive SQL to SQL 2005?

    Thanks so much. I'll try that.

    Don't worry I am doing alot of testing in house before I upgrade in the Live environment.

  • Richard O'Gorman Profile Picture
    Richard O'Gorman 45 on at
    Re: What is the migration path from Pervasive SQL to SQL 2005?

    There's no direct path to SQL2005, since the last Migration Manager tool was for GPV7.5, which pre-dated SQL2005. You'll have to use a SQL2000 intermediary. 

    You're best bet is to perform as much of the GP upgrade on SQL as you can. Migrate from B-trieve to SQL2000 first on GP V7, then continue the GP upgrade on the SQL2000 system. Finally upgrade SQL to 2005. You also don't need to transit through every GP version. I'm not sure of the license implications, but I understand that SQL is backwarldy compatible, so if you buy SQL2005 licenses, you are also entitled to use SQL2000. In any case, you won't be using SQL2000 in production. You should be able to use this path:

    GP V7 B-trieve -> GP V7 SQL2000 -> GP V7.5 SQL2000 - > GP V9 SQL2000 -> GP V10 SQL2000 ->SQL upgrade

    Also, I very strongly recommend a test upgrade with full user testing, because B-trieve to SQL migrations can be challenging. It's a good idea to mindful of hardware changes as well - if you're intending to move to Server 2008 and/or an X-64 platform, then you'll need to do this after the GP and SQL upgrade.

    I hope this helps. Good luck with the upgrade!!

     

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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans