SQL Server Auto-generated Schema - TEXT data type deprecated [BATCH-2740]

[spring-projects-issues]

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