Actions
Task #1665
open
Use of deprecated datatype "image" when using MSSQL
Status:
New
Priority:
Normal
Assignee:
Ondřej Kopr
Category:
Database
Target version:
-
Start date:
05/17/2019
Due date:
% Done:
0%
Estimated time:
Owner:
Description
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:
ALTER TABLE t ALTER COLUMN c VARBINARY(somesize | MAX) ...;
Assigning to Ondra: please plan it for some future product release. Thx
Actions