Activity overview
Latest activity by shuff1203
As you can see in my screenshot it's not white space differences - it's a difference of carriage return types. My guess is someone pasted the script to update the database and SMSS said do you want to change the carriage returns they said yes and then ran it so now when I do a compare it shows that difference in carriage return on the JSON within the two fields. / comments
As you can see in my screenshot it's not white space differences - it's a difference of carriage return types. My guess is someone pasted the script to update the database and SMSS said do you wan...
Peter_Laws said:
Hello shuff1203, Thanks for the question, please could you try setting this option? [image]
That does not work. / comments
Peter_Laws said:
Hello shuff1203,Thanks for the question, please could you try setting this option?
That does not work.
Is there a way to ignore Carriage Return differences?
Is there a way to compare two field values that contain JSON in the columns but tell SQL Compare to ignore the difference in carriage returns? For example when I click to see the differences I get:
Leave foreign keys untrusted
I'm getting a warning on some tables which ultimately leads to a deploy error. The warning says to use "Leave foreign keys untrusted" under Deployment options.
If I edit the project I don't see "D...