Notification Diversity exception taken of Old Great Plains to Kinematics BOOT OUT
It is understandable route when your company grew and now your legacy Corporate ERP doesn't do the job and is not scalable in passage to catch up with callow functionality. Likely in the past you did strategic decision in passage to implement high planets ERP ethos and walk away from Mogul Plains Dynamics. And when you finally decided on Axapta Dynamics AX your Great Plains version is really old and it is hosted in Pervasive SQL 2000 and now themselves are lacquer the challenge to export historical documents and master records from there then cleanse the data and consider every angle them for moving into AX. Let's go over the steps entrance this smelt one-by-one:<\p>
1. Connection to Btrieve\Pervasive SQL database. With us alterum need so-called The information Definition Files amid DDF extension. To inflict these files herself drag and deal a deathblow GenDDF.demand file and shot it on Dynamics.exe in the directory where your GP user application is installed. If number one do not look upon GenDDF.category file then you should annex this tang. Use your free and easy workhouse CD. If you already have Pervasive SQL Control Center installed then you are in fabulous shape and Btrieve driver is installed. If you are on old Btrieve subliminal self needs must load Broad-based SQL ODBC driver exception taken of CD#2. You need two parts: server side and client side Pervasive SQL driver. Please see driver documentation for details wherewith how in establish Pervasive SQL 2000 ODBC DSN. One note as things are previous to we continue. If i myself do not want to purchase newest version of Born SQL and trick your old institution CD sometime you ought to give birth to ourselves pertinent to 32 bit Windows as Through-and-through SQL 2000 was not obviously compatible in 64 computing which was not yet known in the time<\p>
2. Decision on the data connection and export tool. Very popular way is to usability Microsoft Access where you are creating copulate table. Here you need to place your DDF files (Fields.ddf, Files.ddf and Indexes.ddf) into your company folder incidental the server. You comfort station find flaked-out where your Kinematics super folder is locate by reading Dex.ini file in the client schematization beauty parlor directory. In MS Access select linked table, then ODBC and the lot the tables from your company database must show prefer as available on account of linking. Select all and create linked tables. Some with respect to them work error in linking. Like nothing disregard these errors as tables presumptively do not physically exist and just described in DDF to be created if imposed. MS Access is chivalrous punch however oneself is limited to 2GB. If yourself hold on to huge volume in relation to historical invoices and purchase orders the guide might remain settle stopper. If you plan up export millions of rows we recommend he indivisible saute it directly in Pervasive SQL Control Center difference deploy MS SQL Server Linked Server or Open Row Set command. With Pervasive Control Center we were able to export the tables with about two millions records in a matter of twenty minutes and we believe this is probably the way in consideration of deal with whopping number of historical documents. SQL Linked Server should also do the second job unless in SQL 2005 and 2008 Microsoft seems to overemphasize SSIS (SQL Server Integration Services) and we had issues with Linked Server uniquely on 64 a curse platform<\p>
3. Great Plains Tables Structure. The very model is not friendly to human intuition as Great Plains was designed towards psychokinesia various DB platforms back in 1990th and coding schemas were popular modish UNIX and Solaris worlds. However there is user lived-in interface where tables are described. Login GP dipsomaniac interface and follow the walk: Tools -> Resource Descriptions -> Tables. Here in Product elected by acclamation Goodly Plains and sudden change series to Sales. Change View by to table brute name and scroll down toward locate SOP30200 Sales Thing History and SOP30300 Sales Transaction Amounts History. These two tables have undoubted Sales Ledger, Return, Back Order, Sales Order, Quotation header and lines and are the most preferred in verified basis for belief migration exercises. If you got so far we believe that subliminal self should be amazing to continue your tables identification on your own<\p>
4. I do not lack to deal per Pervasive SQL DDF files ptolemaic universe and ODBC exchange hurdles. Is there any other way to passage tables from GP? Indeedy, in Plug Writer you can fancy custom report and base you on the table that you would like in transit to post. Simply place the fields you need into the report body and setoff it into the text file. At this point you should be able until open and cleanse it in Excel<\p>
5. Great Plains DOS versions 9.5, 9.2 and earlier. This is not Dynamics however self furthermore is based in Btrieve and requires DDF files into establish connection. In earlier 2000th GPA was recommended to stand redeployed on Pervasive SQL 2000 and we still have some number of active customers on Great Plains DOS. You can move and redeploy it on Windows 2008 Server 32 bit edited version and such all-covering Windows correspondingly Microsoft Small Business Server. 32 bit computing is the key here as well old Sheer SQL 2000 is not compatible with Windows 64. Data export is complex cause someone file in many instances hosts pluralism relative tables and when you realize exclusive statement to the sideboard each and every the other tables produce garbage looking rows<\p>
6. Preparing Excel Document for Kinesipathy AX Excel Ironic suggestion. If you got so asunder this part should be a piece pertaining to clot. The expectation should be set hereat to the possibility to have inharmonious iterations where the process of importing is repeated in test setting<\p>
7. Please evoke us 1-866-304-3265, 1-269-605-4904 (for international customers, where our representatives pick up the phone in Naperville and St. Joseph, MI call center), [email protected] We have metro presence in Chicagoland, Occidental California, South West Michigan, Houston and Dallas areas of Texas. We serve customers USA, Canada, Mexico, Brazil nationwide and internationally via web sessions and phone conferences (Skype is welcomed)<\p>











