What are the challenges you face when working across database platforms? Take the survey

Cannot convert data type nvarchar(max) to text when updating text field

Hi! I'm comparing two databases' data, and, when running the update script against the target (SQL 2014), for one (of the many) text fields that are getting updated, I get the error: Cannot convert data type nvarchar(max) to text. I'm using SQL Data Compare 11. Any ideas? Thanks.


Sign In or Register to comment.