29

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?

Oreo
  • 529
  • 3
  • 16
Ramūnas
  • 1,494
  • 18
  • 37

2 Answers2

1

Not really a workaround or a solution, but I remember having this issue on Visual Studio 2017 and the issue stopped arising when I upgraded to Visual Studio 2019.

Glanchez
  • 46
  • 4
  • This does not really answer the question. If you have a different question, you can ask it by clicking [Ask Question](https://stackoverflow.com/questions/ask). To get notified when this question gets new answers, you can [follow this question](https://meta.stackexchange.com/q/345661). Once you have enough [reputation](https://stackoverflow.com/help/whats-reputation), you can also [add a bounty](https://stackoverflow.com/help/privileges/set-bounties) to draw more attention to this question. - [From Review](/review/late-answers/33270660) – Ross Presser Nov 30 '22 at 14:37
  • I agree Ross Presser, I don't have a solution and I can't comment on the original question (not enough reputation). The "solution" would be to upgrade to Visual Studio 2019, but the original question was related to Visual Studio 2017, which I guess was the latest available version at the time. Do you think I should delete my answer? – Glanchez Nov 30 '22 at 21:27
  • VS2022 has options in the settings menu to configure whitespace handling - no idea if that was in VS2017 and don't have a copy available to check, but worth a look. – Ian Apr 04 '23 at 20:59
-6

You may want to check your error list in Visual Studio. There is a good chance that there are dependent objects (e.g. Users, Logins, Tables, Keys) that the object is dependent on and is missing and not synchronized. If you synchronized those missing object to your database project first it may resolve your issue.

HSW
  • 1