Great Plains Consultant Chicago, San Diego: Dynamics GP Upgrade

December 22, 2017 by  Filed under: Computer 

Microsoft Dynamics GP ERP, or former name Great Plains Dynamics is available on Microsoft SQL Server platform only (current version GP 10.0), earlier versions: 7.5, 7.0, 6.0, 5.5, 5.0, 4.0 were also available as Great Plains Select on Pervasive SQL 2000 (which is successor of Btrieve) and Ctree/Faircom

In this small publication we will try to orient you even inthe case when you are on Great Plains Accounting for DOS or Windows to upgradeit all the way up to current Dynamics GP version 10.0


1.      If you are on Dynamics GP 8.0, or 9.0.  Upgrade is simple enough, just take toconsideration that Great Plains 8.0 is not compatible with SQL Server2005.  However if you have GP 8.0, youstill can move it to SQL Server 2005 (just databases and user security – pleaserequest user logins transfer technical knowledge paper from your Great PlainsVAR) and then do upgrade on SQL 2005 level. Upgrade is just one step – please apply the most recent service pack toGP 10.0, currently SP3 (December 2008)


2.      If you are on GP 7.5, 7.0 on Microsoft SQLServer 2000.  We recommend two steps:first step – upgrade to GP 8.0 and then go to 10.0 on the second step.  Please, be aware, that if you are onPervasive SQL 2000 or Ctree – you will need migration to Microsoft SQL Server –Migration tool is available from Microsoft Business Solutions, request it fromyour Great Plains Reseller or consultant, read next paragraph for additionaldetails


3.      Migration to Microsoft SQL Server.  If you are with older version of Great Plains(please, if you are on GPA for DOS, be patient, your solution is few paragraphsdown), we recommend you make upgrade on the same DB platform: Pervasive SQL orCtree all the way up to version 7.5.  Andthen on GP 7.5 you migrate to 7.5 on Microsoft SQL Server 2000.  Migration tool works simple – it reads yourdata on Pervasive/Ctree and through ODBC connection moves it to GP 7.5 on MSSQL Server.  Naturally – you will need tocreate blank companies on MS SQL Server with exactly the same accountsegmentation, plus refer for additional setup in Migration manual


4.      Great Plains Accounting for DOS.  We recommend you to migrate to GP 7.5,initially update GPA to version 9.5.  Ifyou do not have the budget to migrate away from GPA, you may consider strategyof moving GPA server from old Novell or Windows NT to Windows 2003 Server,where you mount it on Pervasive SQL 2000. Special setting must be done, this step requires consultant help

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

You must be logged in to post a comment.

Prev Post:
Next Post: