| How to delete the user? This is the first problem you | | | | Now we would like to stress you the need to move |
| encounter - when user shuts down the computer - | | | | away from Pervasive SQL 2000/Ctree platforms - |
| Great Plains doesn't have the command to log off | | | | you are in trouble - Microsoft Business Solutions cuts |
| the user and when user tries to login the next day - | | | | technical support for Microsoft Great Plains 7.5 and |
| she gets error message that user is already logged | | | | prior on these platforms. This means not only the |
| on. The fix: | | | | support, but also tax updates (especially Payroll and |
| Microsoft SQL Server - open SQL Query Analyzer, | | | | Federal Magnetic Media).What is migration from Ctree |
| switch to DYNAMICS database and run the following | | | | Pervasive.SQL 2000 to MS SQL/MSDE? MBS has |
| script: DELETE ACTIVITY WHERE | | | | migration tool. You need first to install Great Plains on |
| USERID='KATHY'.Pervasive SQL/Ctree - if you have | | | | SQL Server with exactly the same account |
| more than one user registered you can delete the | | | | segments structure and then install migration tool (it |
| user from GP: System->User Activity->Delete User. If | | | | is Dexterity chunk) on your ctree/Pervasive |
| you like to work on the file level - ask all the users to | | | | workstation - then, when you integrate the chunk - |
| log off. On the server, where you have your Great | | | | you will map it to target SQL-based Great Plains |
| Plains files structure - DYNAMICS is the root, in | | | | Company, select all system and company tables, click |
| SYSTEM folder delete ACTIVITY.* files | | | | the button and it will move all your tables one-by-one. |
| How to unlock the batch? This happens when user | | | | In the case when your Great Plains ctree/Pervasive |
| posts the batch and has her computer crashed (via | | | | has third parties - you need to check if the vendor |
| surfing the internet - smile - or things like this) | | | | has migration tool - otherwise you have to do manual |
| General tip - Great Plains recommends to logoff and | | | | move, use SQL Linked server to your legacy dataDo |
| then login back with the same user id. Then Great | | | | I need consultant? It is probably good idea to have |
| Plains will prompt the user to recover posting batch. | | | | consultant to do the upgrade. We strongly |
| Unfortunately it doesn't work in 70% of the casesMS | | | | recommend you to use consultant in the following |
| SQL Server - the batch record is stored in Batch | | | | cases |
| Header table: SY00500 in the company database. The | | | | You have Dexterity customizationYou are doing |
| fields to clear are: BCHSTTUS and MKDTOPST. In | | | | migration from Pervasive/Ctree to Microsoft SQL |
| some cases you have to delete the record from | | | | Server/MSDE, especially when you have third-parties |
| SY00800 from DYNAMICS db.Pervasive/ctree - you | | | | without migration toolsYou have a lot or |
| have to install ODBC driver for Pervasive or Ctree | | | | ReportWriter Modified Great Plains ReportsYou have |
| and hook the tables: SY00500, SY00800 with | | | | old version of Great Plains: Dynamics or eEnteroprise |
| Microsoft Access - use linked tables technique | | | | 6. |