Versions Compared

Version Old Version 1 New Version 2
Changes made by

Andrew Hill (Deactivated)

f.anwar

Saved on

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. 

 

...

Panel
Warning
titleADVISORY NOTICE

DBConvert - from Oracle to SQL

When DBconvert is used to convert an Oracle database to MSSQL, any Orac6le data columns of type CLOB will get converted to a MSSQL data column of type NVARCHAR(4000)., however, PolyGone column in table SP920_REGION_POLYGON needs to be NVARCHAR(MAX).

Note: SP920_REGION_POLYGON is required for Here maps implementation in ServicePlanner (planned to be release later this year), Schema change is introduced in 11.1 to avoid another Major release due to change in the database schema.

  • The POLYGON column in table SP920_REGION_POLYGON  needs to be changed to NVARCHAR(MAX) as some of the data that will be loaded into it for Planner will exceed 4000 bytes. This change should be done immediately after DBconvert.