Great Plains Consultant: Migrating GP from Pervasive to MS SQL

Sep 8
05:55

2008

Andrew Karasev

Andrew Karasev

  • Share this article on Facebook
  • Share this article on Twitter
  • Share this article on Linkedin

Microsoft Dynamics GP ERP requires regular maintenance and support – version updates, new modules setup and implementation, new users training, data recovery and fixes (such as unlocking the batch, stuck in posting process).

mediaimage

In this small publication we would like to give you highlights on moving old version of Great Plains Dynamics from Pervasive SQL 2000 or Ctree database platform to Microsoft SQL Server 2000 or 2005.  If you are on Btrieve/Pervasive,Great Plains Consultant: Migrating GP from Pervasive to MS SQL Articles likely that your GP version is 7.5, 7.0, 6.0, 5.5 or 5.0.  There might be multiple reasons to update Great Plains version: outdated as the hardware old Windows NT Server, the need to add new Great Plains modules (you can’t get them for your old version) to name a few

1.      Migration tool.  We recommend you first to upgrade your GP version to 7.5 and deploy migration tool for this version to move your databases to Microsoft SQL Server platform.  The technology is simple: you install exactly the same empty companies on Microsoft SQL Server 2000, where you will need to pay special attention to account framework setup (number of segments, their length, etc.).  Do only setup, please check migration manual.  Then from your Pervasive SQL GP you should create new ODBC connection to MS SQL Server – at this point you are ready to launch Great Plains migration

2.      Migration issues, if any.  Again, so far what we saw were the problems associated with different account structure – you should move old data into exactly the same accounts framework.  If you make your segments longer, then it is not a big problem, assuming that you are OK to see blank spaces in Account maintenance window

3.      GP Standard software license.  If you are on Ctree or Pervasive, your current license key will not allow you to work with Microsoft SQL Server based GP Standard.  In order to get new license you should be current in Microsoft Business Solutions annual maintenance or also known as annual enhancement program.  If you are current, then your Great Plains VAR should be able to obtain new GP Standard key from Microsoft

4.      Upgrading to current GP version.  At this time it is version 10.0.  From 7.5 we recommend you two steps: 7.5->9.0 and 9.0->10.0.  Please, do not forget to apply service packs when you are doing each step