Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

In SSDT Schema Compare how do I ignore differences in objects of type "Schema"

From the Schema Compare Options, I deselected all Object Types:

Schema compare object type options

It still shows me differences in Schema objects:

Difference table showing schema objects

I scrolled through the big list of General options, and none of them appeared to do this:

General options

like image 950
Keith Walton Avatar asked Jul 17 '13 20:07

Keith Walton


1 Answers

I hacked it. If you save the compare, you can add this to the file:

  <PropertyElementName>
    <Name>Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlSchema</Name>
    <Value>ExcludedType</Value>
  </PropertyElementName>

You'll see where when you open it. This setting is not in the UI, but is apparently supported.

like image 166
Keith Walton Avatar answered Oct 10 '22 16:10

Keith Walton