SQL Server Auto-generated Schema - TEXT data type deprecated [BATCH-2740] #864
Description
CorwinNewall opened BATCH-2740 and commented
Please see the auto-generated schema-sqlserver.sql.
As per the given reference URL, the TEXT data type will be deprecated in a future version of Microsoft SQL server. Ideally whatever generates the SQL should be changed to generate VARCHAR(MAX) to maximise compatibility with future versions.
The auto-generated SQL column has had a TEXT data type for a very long time so technically most versions are affected, not just the Affects Versions listed.
I do not know if changing to VARCHAR(MAX) breaks anything.
Affects: 2.2.7, 3.0.9, 4.0.1
Reference URL: https://docs.microsoft.com/en-us/sql/database-engine/deprecated-database-engine-features-in-sql-server-2017?view=sql-server-2017