5,454 questions
Visual Studio Database Project - Compare line ending CR LF vs LF
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 11%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mirek
6
Reputation points
Hi,
Is it possible that in the Visual Studio Database Project when comparing, database <==> project, turn on ignoring line breaks?
Currently, I have a database in which some of the objects belong to a structure that is used by a third party that ends with LF characters only.
As a result, despite the lack of differences in the objects between the database and the project, it shows that there are differences. Yes, they are, but only at the level of the end of the line, i.e. in the project we have CRLF and in the base we have LF.
PS: This is not azure-sql-database but Visual Studio Database Project
Best Regards
Developer technologies | Visual Studio | Other
{count} vote
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Navtej Singh Saini 4,226 Reputation points Microsoft Employee Moderator2021-03-23T23:46:58.007+00:00 We have added the tag for Visual Studio team for further help regarding this.
Regards
Navtej S -
Mirek 6 Reputation points
2021-03-25T14:59:58.843+00:00 Maybe I will describe the process step by step.
- I am creating a project "Visual Studio Database Project".
- Right click on the newly created one, select "Import / Database"
- We have a freshly imported database for the project
- Again I right-click on the project but choose the "Schema Compare" option
- And despite the fact that I imported the entire database a moment ago, "Schema Compare" shows me the differences again, because there are differences at the end of the line.
And hence the question, is it possible to somehow turn on the ignore option?
Sign in to comment
Sign in to answer