Release Notes - 201718 - GUID Conversion

Release Notes - 201718 - GUID Conversion


Release

201718 – GUID Conversion

Release Date

Sep 2018

 

1.  Summary

 

The GUID conversion project is essentially about converting data type from Guid to bigint.

 

GUID is a 16 byte binary SQL Server data type that is globally unique across tables, databases, and servers. 

The int data type is the primary integer data type in SQL Server. The bigint data type is intended for use when integer values might exceed the range that is supported by the int data type.

 

Benefits of the GUID conversion project are as follows:

 

           1. Performance improvements and ability to handle larger volume of applications

           2. Opportunity to adjust the nightly maintenance window and allow Clearmatch portal to be available till 11PM AEST (as previously requested by SocietyOne).

    3. Opportunity to finish DayEnd earlier than 8AM AEST SLA time (even with late start of maintenance window the previous day).

 

 

2.  Take Note Of

 

  • No new portal content blocks have been added.
  • No new custom content blocks have been added. 
  • No new security permissions have been added.
  • No new display variables have been added. 
  • No new decision tree variables have been added.


3.  Release Details




Conversion of data type from GUID to bigint

 


 


 

4.  Data Warehouse

 

The CMKey field on most dimensions has changed from Guid to bigint.

 

This does not affect the data warehouse primary keys at all, and therefore should have no material impact on SocietyOne.

 

5.  Portal content (Content Blocks, Validation Messages, Help Messages) - N/A


6.  Security Settings Added - N/A


7.  Documents to Reference

Title