How can we help you today? How can we help you today?

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

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

ThomasPizzo
0

Comments

4 comments

Sort by
  • mattchandler
    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.
    mattchandler
    0
  • Mark J
    Hi Thomas

    Sorry for the delay on this - the newlines problem should now be fixed as of SQL Data Compare 12.4.4.4771.
    Mark J
    0
  • aryelik
    This issue is still happening in 13.1.5.5427. Is there an option to ignore the newlines?
    aryelik
    0
  • Ernest
    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.
    Ernest
    0

Add comment

Please sign in to leave a comment.