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

ivanpelly

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.

Dan_J

Hi @ivanpelly

Thanks for reaching out to us regarding this.

Regarding the error you are seeing, this page from our documentation details which data types can be compared: https://documentation.red-gate.com/sdc/troubleshooting/unexpected-behavior-technical-questions/which-data-types-can-be-compared

I also note that you are currently using a very outdated version (v.11) of SQL Data Compare, from around 2015/16. To ensure you have the most updated features and enhancements available we suggest updating to the latest version of SQL Data Compare (v.15.0.7 - https://download.red-gate.com/checkforupdates/SQLDataCompare/SQLDataCompare_15.0.7.23280.exe).