JSON
The tool needs support for the JSON data type. SQL Data Compare errors out with "Field Permissions doesn't know type [sys].[json]"
4
votes
This is supported as of SQL Data Compare version 16.0.5.28494 released in Jan 2026 - https://documentation.red-gate.com/sdc/release-notes-and-other-versions/sql-data-compare-16-0-release-notes. Please update to the latest version and contact support if you have any issues.
-
Shravan
commented
Is there any timeline on this or planned in future releases?
-
Steven Perry
commented
The tool needs support for the JSON data type. SQL Data Compare errors out with "Field Permissions doesn't know type [sys].[json]"