| Historically Great Plains Software introduced Great | | | | on Great Plains Standard 8.0, you will need to migrate |
| Plains Select, which was available on Pervasive SQL | | | | to Microsoft SQL Server 2000. If you are on |
| 2000 and Ctree database platforms, not on Microsoft | | | | Dynamics GP 9.0 or 10.0 you can either migrate to |
| SQL Server. Later on, when Microsoft acquired | | | | SQL Server Select edition or SQL 2000 or 2005 |
| Great Plains Software, it decided to switch from | | | | Standard or Enterprise. Microsoft Business Solutions |
| Pervasive and Ctree to newly introduced Microsoft | | | | recommend you simply to reattach existing Dynamics |
| SQL Server Desktop Edition or MSDE. MSDE, which | | | | and company databases files to newly installed SQL |
| is scaled down Microsoft SQL Server 2000 placed the | | | | Server |
| limit on its database size to be 2GB. Then in 2004, | | | | 3. If you do not have support contract with |
| Microsoft Business Solutions came out with incentive | | | | Microsoft and not sure who is your existing Great |
| to allow Great Plains Standard 7.5 users to obtain | | | | Plains VAR. All written above is definitely cool for |
| registration key for running GP on SQL Server 2000 | | | | those who are current in Dynamics GP annual |
| platform free of charge. If you are crossing 2GB DB | | | | enhancement program, which allows you to have |
| limit on MSDN, you should consider the following | | | | access to your Customer Source, where you can get |
| actions: | | | | your new Great Plains version reg key. If you lapsed |
| 1. Purge Transaction History and then rebuild | | | | in annual enhancement, you will have to select Great |
| database. Good idea to work on file rebuilding level. | | | | Plains Reseller or consultant, sign Change VAR form |
| Purging transaction history, however might not be a | | | | to your new GP Partner, and then your new VAR will |
| feasible option, especially if your Great Plains users | | | | have access to your historical Great Plains |
| have to look up into historical data for your customers, | | | | Registration Keys |
| vendors, employees, salespeople, etc. Good idea is | | | | 4. From MSDE 2000 to SQL Express |
| also check the size of company DB transaction log. | | | | 2005. In SQL Express you have 4GB DB limit, which |
| 2. Migrate to Microsoft SQL Server 2000 or | | | | is good postponing option, however please know that |
| 2005. If you are on GP version 7.5 – likely that this | | | | you will need to upgrade to at least Great Plains |
| option is not available – you will have to obtain new | | | | Dynamics GP 9.0. Last warning. |
| reg key from Microsoft Business Solutions. If you are | | | | |