v68 Single Database Upgrade Pre/Post Checks

Owned by Andrew Paydon
Last updated: Sept 25, 2017
1 min read

As there is a large architectural change when upgrading to version 68, the following will assist in this process.

Pre-checks

  1. We strongly urge you to have a test server upgraded before production
    1. Like for like of your production server, including all 
      1. Security
      2. File structure
      3. User objects
  2. Run the Prechecker before requesting an upgrade
    1. Can be run on production servers without affecting information
    2. Resolve errors
    3. Attempt to resolve any warnings
  3. Identify any 3rd party integrations you may have
    1. Applications
    2. SQL User Objects
    3. Reports
    4. MSQueries

Post-checks

Programs

Can you continue to run the Synergetic suite of programs that you normally use

  1. SynMain
  2. SynWeb
  3. Portal
  4. Online Application
  5. Onine Enquiries
  6. Online Events
  7. Form Builder
  8. Application Portal
  9. SynWeb Service
  10. CoreAPI
  11. Synergetic Service
    1. DocMan
    2. Report Schedule
    3. Absence Notification
    4. VSN
    5. SIF
  12. SynAPI
  13. Crystal Reports
  14. SSRS
  15. DBPatcher
  16. SADT
  17. Study Period
  18. SynMainL
  19. SynMobile

3rd Party applications

While Synergetic testing has mostly been around confirming existing functionality continues to run without error the majority of checks that Synergetic cannot necessarily check are 3rd party integrations

  1. Applications
  2. SQL User Objects
  3. Reports
  4. MSQueries

Report (available v68.10)

A crystal report has been included in the System module.  This reports on any issues or discrepancies that may have been detected at the time of migration.

For example:

  • Mismatch of record counts in tables
  • Missing/broken sql objects (eg views, stored procedures, functions, etc)
  • Mismatch of primary/foreign keys

Module: SYS

Report: v68 Upgrade Post Check Results

Please note, if the report is blank, there were no reported issues.