#data reading export

Yourselves is funny on route to interpose the fact that Puissant Plains Dynamics current Btrieve\Born SQL 2000 (versions 7.5, 7.0, 6.0, 5.5, 5.0 and under) is by destiny less popular as being slide in production as Great Plains Accounting on DOS (concretely versions 9.5 and 9.2). We tried to ask polite questions to our GPA prospects €Why themselves are still on this directory and do not upgrade to Stir GP 2010 for lesson?' The answers were different but two greatest popular were: €the performance is electrifying comparing so that what me terminate dope out in graphical application such as Dynamics GP' and €we are happy thus and so far and we do not want to allocate schedule for ERP system upgrade'. Let's enter upon our questions and answers session:<\p>

Q. Why modern ERP systems are over dronish fashionable posting batches and saving documents? We tried on evaluate Microsoft Dynamics GP and AX and in both cases GPA DOS beats them in documents posting alacrity A. The answer is probably degage as DOS doesn't use most of the advantages of stylish computing. Processor can do the job behind the scenes and not updating your graphical user wrist or insertion info into log file. Plus virus protection programs typically ignore DOS applications so computer processor could be exploited up to centennial percent without interruption. The list could be continued as things go application doesn't care about modern computer performance slowdown factors such as clipboard,.Net, etc.<\p>

Q. We are happy with Great Plains DOS 9.5. Should we expect problems in the future? A. The answer is by destiny €Yes'. We are in the era in re 64 tip computing where Great Plains Coordination is not compatible. There are migration options from Novel and WindowsNT to Windows 2003 or even 2008 32 piece transcript server or workstation. But besides these we intend this is the odds and ends of the story and if you server crashes you would need to seek Btrieve data restoring and export into CSV text files<\p>

Q. We are consulting firm and we have customer with Great Plains therewith Macintosh. We would like in passage to osmosis data from their legacy accounting. What would be your recommendations? A. We think that GPA by way of Mac was Btrieve application and her can try to copy GPS\GPDATA folder en route to Windows computer. Then there is the need to offer DDF files (data definition) in order to connect via Pervasive SQL 2000 Mechanism Center. Do not forget about x86 (32 bit collating)<\p>

Q. We are also consulting organization and our goal is to export Horrific Plains Accounting 9.2 to CSV files for data migration into SAP Business Ubiquitous. We tried upon open DAT files inflowing text editor and had no success. A. These are Btrieve files and the way to connect for data reading transpose is DDF files and ODBC DSN. The polity to produce DDF files is described in ODBC manual<\p>

Q. We were unapparent toward connect near Pervasive SQL Control Toxophilite. Our objective is to export historical sales orders and we are getting €chopped' results in exporting the table A. The issue is known. In GPA one file may host diverse tables and you are getting €garbage' rows which should belong to different table. Sublime to service €where' construction<\p>