| > | | | | will need migration to Microsoft SQL Server — |
| Microsoft Dynamics GP ERP, or former name Great | | | | Migration tool is available from Microsoft Business |
| Plains Dynamics is available on Microsoft SQL Server | | | | Solutions, request it from your Great Plains Reseller |
| platform only (current version GP 10.0), earlier | | | | or consultant, read next paragraph for additional |
| versions: 7.5, 7.0, 6.0, 5.5, 5.0, 4.0 were also available | | | | details |
| as Great Plains Select on Pervasive SQL 2000 (which | | | | |
| is successor of Btrieve) and Ctree/Faircom | | | | 3. Migration to Microsoft SQL Server. If |
| In this small publication we will try to orient you even | | | | you are with older version of Great Plains (please, if |
| in the case when you are on Great Plains Accounting | | | | you are on GPA for DOS, be patient, your solution is |
| for DOS or Windows to upgrade it all the way up to | | | | few paragraphs down), we recommend you make |
| current Dynamics GP version 10.0 | | | | upgrade on the same DB platform: Pervasive SQL or |
| | | | | Ctree all the way up to version 7.5. And then on GP |
| 1. If you are on Dynamics GP 8.0, or 9.0. | | | | 7.5 you migrate to 7.5 on Microsoft SQL Server |
| Upgrade is simple enough, just take to consideration | | | | 2000. Migration tool works simple — it reads |
| that Great Plains 8.0 is not compatible with SQL | | | | your data on Pervasive/Ctree and through ODBC |
| Server 2005. However if you have GP 8.0, you still | | | | connection moves it to GP 7.5 on MS SQL Server. |
| can move it to SQL Server 2005 (just databases and | | | | Naturally — you will need to create blank |
| user security — please request user logins | | | | companies on MS SQL Server with exactly the same |
| transfer technical knowledge paper from your Great | | | | account segmentation, plus refer for additional setup |
| Plains VAR) and then do upgrade on SQL 2005 | | | | in Migration manual |
| level. Upgrade is just one step — please | | | | |
| apply the most recent service pack to GP 10.0, | | | | 4. Great Plains Accounting for DOS. We |
| currently SP3 (December 2008) | | | | recommend you to migrate to GP 7.5, initially update |
| | | | | GPA to version 9.5. If you do not have the budget |
| 2. If you are on GP 7.5, 7.0 on Microsoft | | | | to migrate away from GPA, you may consider |
| SQL Server 2000. We recommend two steps: first | | | | strategy of moving GPA server from old Novell or |
| step — upgrade to GP 8.0 and then go to 10.0 | | | | Windows NT to Windows 2003 Server, where you |
| on the second step. Please, be aware, that if you | | | | mount it on Pervasive SQL 2000. |
| are on Pervasive SQL 2000 or Ctree — you | | | | |