IdStory Identity Manager

Task #1665

Updated by Petr Fišer almost 5 years ago

Since Q3/2017, Microsoft deprecated the "image" datatype in MS SQL Server. CzechIdM uses this datatype in various places and we should consider changing them to supported datatypes (e.g. varbinary). 
 Source: https://docs.microsoft.com/en-us/sql/t-sql/data-types/ntext-text-and-image-transact-sql?view=sql-server-2017 . 

 Ondra tested this and we can safely transform the datatype of a column in the Flyway with: 
 <pre> 
 ALTER TABLE t ALTER COLUMN c VARBINARY(somesize | MAX) VARBINARY(MAX) ...; 
 </pre> 

 Assigning to Ondra: please plan it for some future product release. Thx

Back