Recommended: Click here to run a Free driver update scan »
Microsoft Great Plains is strictly MS SQL Server application, starting with version8.0, which is about since 2004. This fact opens SQL scripting and stored proceduresapproach to software developer or technical consultant, who is assigned to the dataconversion phase, say from Accpac or MAS 90 to Microsoft Dynamics GP. As simple ifmight look  this approach requires close familiarity with GP architecture, itsMicrosoft Dexterity database features (such as DEX_ROW_ID). So, here we would liketo orient you in which set of tools should be tried first, which the second and thethird. Data export. In the case of Accpac you have either Pervasive SQL 2000 or MS SQLServer database, so, you can pull data from Accpac via ODBC connection. You maycreate Linked Server from MS SQL Server Enterprise Manager  this will let youmanipulate Accpac Pervasive SQL data directly from MS SQL Server. In the case ofMAS 90 you can use reports and send them into text files and then import them intoMS SQL Server custom database Period Balances approach. In this case you decide that in GP you will have periodbalances in GL for each month of the year plus for the beginning of current year. You will need to prepare General Ledger transactions for year opening and each month Master Records migration. In order to migrate such records as customers, vendors,accounts, employees, addresses, we recommend you first to consider GP IntegrationManager. If IM is not available in your case, you can try to migrate data via SQLscripting directly into RM00101  customer master table, PM00200  vendor mastertable, etc. Prior to SQL migration  make DB backup in case if you need to rollback. When you try one step (like customers), open GP workstation and run checklinks: File->Maintenance->Check Links Historical Data migration. We discourage you from doing historical transactionmigration to GP, instead we recommend you to keep your old Accpac or MAS 90 forinquiry only. If history migration is absolutely necessary, consider firstimporting transactions via IM and then post them in modules (if you plan initialbalances approach, see above, in posting settings unmark Post to GL:Tools->Setup->Posting select series and origin). If IM is not available, you shouldnever run Check Links against your historical migrated data in the future
Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.comhe lp@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving GP customers locallyin Houston and Dallas metros: Rosenberg, Katy, Richmond, Sugar Land, Brookshire,Creek Village, Missouri City, Bellaire, Hunters, Pearland, Manvel; in Chicago metro:Naperville, Aurora, Plainfield, Romeoville, Elgin, Schaumburg, Batavia, Bolingbrook,Lemont, Oak Brook, Lombard, Westmont, Darien, Mooseheart, Geneva, Winfield, BurrRidge. Remote support service is available USA and Canada nationwide: California,Quebec, Ontario, BC, Colorado, Utah, Florida, Wisconsin, Pennsylvania, Ohio,Arizona, Kansas, Alabama, Louisiana.
