When I run the Visual Studio 2019 SQL Schema Compare tool, it correctly identifies the differences between 2 databases. Then whenever I try to "Update" or "Generate SQL" to update the schema on my target database, Visual Studio crashes.
Looking around it looks like this issue has been around in previous versions for a number of years. I tried applying the solutions I found online. One was to by unchecking the Option "Optimize rendering for screens with different densities" in Options - General. Another was to clear Visual Studio ComponentModelCache. Neither solution worked for me.
Is there a reliable way to get around this bug?
Alternatively, is there another (hopefully free) tool that will do this. My needs are occasional so the VS solution would be preferable.
There is no way to get around the bug that crashes Visual Studio, either using "Update" or "Generate SQL" either in Visual Studio 2019 or (just checked) the newly released Visual Studio 2022.
Please post here if others are not getting this bug or if you have a workaround.