Microsoft SQL has de-supported certain data types. IThe Learn installer has been modified to alter the Learn schema in support of the new datatypes. Building Blocks utilizing the de-supported data types should be refactored to support the new data types.
MS SQL Data Type Changes
Certain data types have been de-supported in MS SQL. The following table provides the replacement data types:
|De-supported Data Type||New Data Type|
Note that ntext is mapped to nvarchar(max), text is mapped to varchar(max), and image is mapped to varbinary(max)
Building Blocks Impact
Building Blocks using the de-supported data types should be refactored to support the new data types and thouroughly tested.
For optimal performance the Learn Installer/Updater requires 25% more database space in advance of performing the update to support the data type migration.