| If you have solid Great Plains VAR support from your | | | | scripts, available from Microsoft Business Solutions |
| local partner or certified consultant, then this routine | | | | Partner or Customer Source (if you are not current |
| should be entrusted to their hands and you should not | | | | with GP annual enhancement program, likely that your |
| worry about it. However if you are without support, | | | | customer source expired too) |
| typically when you are using one of historical Great | | | | |
| Plains versions: 7.5, 7.0, 6.0, 5.5, 5.0 or even GP 8.0 and | | | | 2. Great Plains on Ctree. This version is |
| you are not sure who is your current Great Plains | | | | easily transferrable to new server, assuming that you |
| Partner, then you need to local Microsoft Dynamics | | | | are on GP 7.5 or 7.0. You should install Ctree default |
| GP consultant for helping you in Great Plains migration | | | | GP on the new server and then copy over files from |
| from one server to another. Let’s consider | | | | your old server. You will need help with Location |
| migration scenarios: | | | | Translation, when you first launch Great Plains. You |
| | | | | can call us to get this help |
| 1. Great Plains on MS SQL Server 2000 (or | | | | |
| SQL Server 2005). In the case of being on MS SQL | | | | 3. Great Plains on Pervasive SQL. You |
| 2000, you need first to understand, that you should | | | | should have Pervasive SQL CD, and you install |
| move it to exact blend of SQL Server. Especially it is | | | | Pervasive server first on the server. If you plan to |
| important if you are on version 7.5 or earlier – these | | | | use GP on Pervasive as Single User Workstation, you |
| versions were sensitive to SQL license. This means | | | | do not need to install Pervasive SQL Server there. |
| that if you are using MSDE, you can’t redeploy | | | | Then simply repeat steps described in #2 |
| Great Plains on new server, where you load MS SQL | | | | |
| 2000 Standard, for example. If you have SQL DBA | | | | 4. Great Plains Standard on MSDE. You |
| in staff – you can ask her or him to simply transfer | | | | follow the same recommendations as in #1, however |
| all the databases, users and security to new server. | | | | we recommend you to use Microsoft SQL Server |
| If you don’t have DBA, then you should have your | | | | 2000 client tools – SQL Enterprise Manager and |
| GP consultant to use GP users capture and transfer | | | | Query Analyzer. |