question

kurtogath avatar image
0 Votes"
kurtogath asked kurtogath commented

Ignore view design changes on Visual Studio Sql server schema compare

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 🧡

sql-server-generalvs-general
image.png (8.1 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, @kurtogath
Could you explain more about "disable the design computation changes on view"? Perhaps you can share me some steps to reproduce and check this issue.

0 Votes 0 ·

Hi, @kurtogath
May I know if you have got any chance to check my reply? Please feel free to share more detailed information to us and it will be very helpful for us to better work out this issue.

0 Votes 0 ·

Hi, i just returned from my vacations sorry for being late.

So, i start my Visual Studio, I use the SQL Server schema compare tool and compare two databases. I use the Microsoft SQL server management studio to work with my databases, and with the views i use the design manager, so the diference between this views are just from the design manager. I just wanted to know if there is an option on visual studio to avoid messageing me that one table of the design manager is is higher than the same table in the other database

0 Votes 0 ·

1 Answer

TomPhillips-1744 avatar image
1 Vote"
TomPhillips-1744 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.