Ignore view design changes on Visual Studio Sql server schema compare

Kurtogath 21 Reputation points
2021-08-05T15:45:57.993+00:00

Hi folks!

I'm using the SQL Server schema compare on Visual Studio 2017 and I want to know how to disable the design computation changes on views. I compare two databases and the only change is that in the views the layout is different, although this is not a major change in how my databases work.. I wonder how can I disable this option, I will add a picture of it if you wonder what I'm saying.

120818-image.png

Thanks 4 your help! Love you all 🧡

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,888 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions
{count} votes

Accepted answer
  1. Tom Phillips 17,721 Reputation points
    2021-08-13T12:32:07.243+00:00

    The schema compare is a simple text compare. So there is no way to exclude these options.

    The best solution is to not use the view designer and remove this information from the view code after generation.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful