Toad World® Forums

LF and CRLF differences not updated in data sync

Data compare on varchar(max) fields detects differences between LF and CRLF line ends but the update script generated by the synchronisation wizard does not updated those. Doing another data compare after updating the target database still brings out these differences.

Visual Studio 2017 SQL Data compare treats these correctly.

I can't use "ignore whitespaces" in Toad as i can't assume these differences are important or not.