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