Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space SCHUD and version 11.1

...

Panel
Warning
titleADVISORY NOTICE

Constraint & Index Re-Creation

Constraints & indexes will be dropped and re-created on some database table columns, as part of the process of converting database column types from char/varchar to nchar/nvarchar.

The ServiceOptimizer Install Guide provides details of how to upgrade your database, including key points to be aware of in the event that:

  • Any changes to constraints and indexes in the ServiceScheduling database have been made; and/or
  • Any additional tables have been created in the ServiceScheduling database which may be incorrectly detected as requiring the dropping and re-creation of constraints & indexes.