Reasons for sticking with TEXT, NTEXT and IMAGE instead of (N)VARCHAR(max) and VARBINARY(max)
- by John Assymptoth
TEXT, NTEXT and IMAGE have been deprecated a long time ago and will, eventually, be removed from SQL Server.
However, they are not going to be discontinued right away, not even in the next version of SQL Server, so it's not convenient for my enterprise to transform thousands of columns right away, even if it is using SQL Server 2012.
What arguments can I use to postpone this migration?
I know there are some advantages in using the new types. But I'm strictly looking for reasons not to migrate my data that is already functioning pretty well in the old types.