I have table with the columns of type NTEXT
. And for some peculiar reasons, the client wants to migrate the column type to NVARCHAR(MAX)
.
While doing so, what all potential threat should I be careful about?
Is there any possibility of data loss for the NVARCHAR(MAX)
limitations?
Best Answer
No. You can alter your tables (Sql 2005+) cf this.
Or, for your convenience:
Or you can supply a view which casts the
ntext
columns tonvarchar(max)
to make the client happy and leave your database unchanged.