Generated migration script is adding a carriage return to a varchar column.

ThomasPizzoThomasPizzo Posts: 1
in SQL Data Compare
We have a table that contains email templates. SQL data compare is adding additional carriage returns to the migration script. We then see differences in the data even though they are the same except for the carriage return. Is their an option to not add additional carriage returns.

oxexgja5g55a.png

Tagged:
· Share on Twitter

Comments

  • mattchandlermattchandler Posts: 52 Silver 2
    Hi Thomas,

    Thanks for letting us know about this. Sorry you've run into this problem.

    We are currently working on fixing some issues around line endings, so I hope that upcoming versions will work better in this scenario.
    Matthew Chandler
    Software Developer on SQL Compare and SQL Data Compare
    · Share on Twitter
  • Mark JMark J Posts: 125 Bronze 5
    Hi Thomas

    Sorry for the delay on this - the newlines problem should now be fixed as of SQL Data Compare 12.4.4.4771.
    · Share on Twitter
  • aryelikaryelik Posts: 1 New member
    This issue is still happening in 13.1.5.5427. Is there an option to ignore the newlines?
    · Share on Twitter
  • ErnestErnest Posts: 4 New member
    This is happening for us in the opposite direction in SQL Data Compare v13.3.2.5875. We have source controlled data with just \n line endings and they're showing up as different than the line endings in the database.
    · Share on Twitter
Sign In or Register to comment.