Add "ignore inconsistent line endings" project option
We have a lot of data in character-based columns that is essentially the same, but because of inconsistent line endings (CR vs CR+LF) cannot be easily confirmed as "identical". For each cell we have to open the viewer and visually inspect whether we only have line ending differences or there are other (meaningful) differences.
Anonymous
shared this idea
-
James Burnell
commented
I really would appreciate this feature too. We have fields where we store dynamic SQL, and depending on how it gets added, we end up with DOS or Unix-style line endings...and the differences get flagged.Please fix.
-
Ernst Raidl
commented
We are also facing the same issue as described before. It would be very helpful to have the desired option to filter out data rows with inconsistent line endings.
-
Vigneshwar
commented
We are facing the same issue with inconsistent line endings and have to go through each record to find the differences and it is killing the main purpose of using the tool
-
If you're comparing procs you might be using SQL Compare instead of SQL Data Compare - we do have an 'ignore whitespace' option in SQL Compare which will mean that different line endings are treated as being the same
-
Anonymous
commented
The tool is pointless for comparing procs, it says all proc are different because of line endings!
