SSDT Schema Compare add blank lines to the schema files

Question

I am using Schema Compare feature in Visual Studio 2017 to compare a database with database project (.sqlproj).

If I apply some changes to the project it also adds blank lines to some of the schema files.

After some investigation I found that I'm not the only one facing this issue. From the number of upvotes I can guess that MS will not fix this issue soon.

Has anyone found any workaround for this?

Answer 1

Microsoft has finally (June 2024) acknowledged and fixed this bug, but it hasn't been released yet. See this link for details.

https://developercommunity.visualstudio.com/t/SQL-Server-Database-Project:-SQL-Schema/10633571?q=schema+blank+lines