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.
Comments
1 comment
-
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).
Add comment
Please sign in to leave a comment.