Migrating from NTEXT to NVARCHAR(MAX)

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?

No. You can alter your tables (Sql 2005+) cf this.

Or, for your convenience:

alter table my_table alter column my_ntext_column nvarchar(max);

Or you can supply a view which casts the ntext columns to nvarchar(max) to make the client happy and leave your database unchanged.

StackExchange Database Administrators Q#1298, answer score: 6