Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have table with the columns of type ntext.And for some peculiar reasons, client want 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?

share|improve this question

3 Answers 3

up vote 3 down vote accepted

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

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

share|improve this answer

"peculiar reason"? Only that ntext is deprecated and damn difficult to work with?

It's a lossless conversion. If you are unsure, use the SSMS GUI designer to generate scripts for you.

share|improve this answer

Is there any possibility of data loss for the NVARCHAR(MAX) limitations?

No. NVARCHAR(MAX) allows for twice as much text (2^31-1 vs. 2^30-1) as ntext.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.