Great Plains Data Export And Conversion: Dos, Pervasive Sql And Ctree

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

by: Andrew Karasev

POST COMMENT

Make The Most Of Your Search Engine Optimization: Suggestions And Tips The Rolling Code Garage Door And Its Benefits The 3 Important Personality Traits Of A Successful Medical Biller And Coder Ways To Help You Get Hired As A Medical Biller And Coder 2 Factors That Can Affect The Salary Of A Medical Biller And Coder Swings And Roundabouts: Whatever Impact Are Profligate Fashion Shows Having On Emerging Fashion Desi Tips On How To Reignite That Spark And Win Your Ex Back! Custom-design Sapphire Engagement Ring And Make Her Feel Special Preventative Medicine And Sports Therapy For Performing Arts Hp C5707a Dds 2 Offering Best Storage And Scalable Solution For Us Commodity Market Precious Metals - Gold And Silver, Mcx God And Silver Updates How To Recover Your Partner And Repair Your Relationship Tamarindo An Awesome Destination For Out Of Season Surf And Dental Care