subject: Great Plains Data Export And Conversion: Dos, Pervasive Sql And Ctree [print this page] Here we would like to review migration from obsolete versions of Great Plains Dynamics including historical DOS 9.5, 9.2 as well as releases on Btrieve/Pervasive SQL 2000: 7.5, 7.0, 6.0, 5.5, 5.0 and earlier.
If you are on MS SQL Server then data export is simple and you just need to familiarize yourself with table structure which could be reviewed: Tools -> Resource Description -> Tables. Just to see if you are able to get it customer master table is RM00101
Lets now review Btrieve data connection. Here you have to produce DDF (Data Definition Files). If you are on Dynamics then there is DDF generation setup file and the task is pretty simple. In the case of DOS version you need to read ODBC manual available on the installation CD
Pervasive SQL 2000 Control Center. This is the tool to connect via ODBC, read available tables (defined in DDF files) and export records. Few comments before we continue. Great Plains on Pervasive/Btrieve was phased out back in 2006 so the tool is compatible with 32 bit computing. In computer stores nowadays you can purchase Windows 7 64 bit this model is not compatible with your old accounting
Exporting from Great Plains DOS, Windows or Mac versions 9.5, 9.2 and earlier. If you are reading this article from Albaspectrum website then you should see code samples and screen shots.
Here the challenge is that GPA DOS hosts the several tables in the same file, meaning that you have to do data filtering.
Our experience is the following. We are exporting via SQL select statement and in the form of SDF file. Then we open in in Write (Microsoft Wordpad) and add 0 columns. At this point it is ready to be cleansed in Excel, MS SQL Server or Access
Lets take few questions
Q. Is it possible to update GPA DOS to Microsoft Dynamics GP 2010?
A. Yes there is migration tool from Great Plains Accounting to Dynamics GP. This approach is recommended as you are preserving your historical data: Posted sales orders, purchase orders, Inventory and GL Entries
Q. We have tons of sales orders and we would like to export them from GPA DOS. What is consulting time estimation?
A. We just did this type of conversion. Pervasive SQL 2000 is slow in exporting. Plus we have to produce SQL scripts. You should expect twenty hours or more
Q. You are so technical. Are you available in USA countryside?
A. We are ready to travel as well as do remote connections via web sessions (Citrix Gotomeeting or you name preferred technology)
For additional information, please feel free to call us 1-866-528-0577 or 1-630-961-5918 (this number works for international customers) or email us help@albaspectrum.com We serve you USA/Canada nationwide via remote support (web sessions and phone/Skype conferences). Local service is available in Western Michigan, Chicagoland, Southern California (LA, Orange County and San Diego), Houston area of the state of Texas
