The following steps are prerequisite to an upgrade. These tasks
MUST
be completed by the client prior to the upgrade. If you require assistance or
clarification with any of these actions please don't hesitate to contact your account manager.
|
|
TASKS
|
Date Completed
|
|
1.
|
You have been sent the Great Plains CD and registration Keys for the version
you are upgrading to
|
|
|
2.
|
Environment checklist completed / updated within last three weeks
|
|
|
3.
|
Before starting perform backup of all SQL database's except tempdb
|
|
|
4.
|
Within Great Plains remove unneeded companies including TWO + PLAY if
operational, in SQL Enterprise Manager drop TWO + PLAY Database.
|
|
|
5.
|
Within Great Plains File Maintenance � SQL Maintenance area, run Update
Statistics and Recompile on DYNAMICS and Company databases for all tables
|
|
|
6.
|
DBCC Checkdb on all SQL databases – Refer Note 1
|
|
|
7.
|
DBCC Checkcatalog on all SQL databases
|
|
|
8.
|
DBCC Checkalloc on all SQL databases (if SQL 7.0)
|
|
|
9.
|
From within Dynamics preform “Checklinks” on all series for all live
companies
|
|
|
10.
|
Information from the Checklinks report must be presented to and signed off by
the CFO.
|
|
|
11.
|
Post all single use batches. If using APOP you MUST post all Payables
Management batches that originated in APOP
|
|
|
12.
|
Perform another backup
|
|
|
13.
|
Clear unnecessary files, ie. Temp, SQL backups, etc.
|
|
|
14.
|
Confirm free space on the SQL servers drives of around 3x the total of all the
SQL databases.
|
|
|
15.
|
The desktop of the workstation doing the upgrade should have free disk space in
excess of 800mb, – Refer Note 2
|
|
|
16.
|
Resolve any problems highlighted by error messages
|
|