Search code examples
visual-studioazurevisual-studio-2013sql-server-data-toolsschema-compare

SSDT schema compare - ignore system service brokers (VS 2013)


I have a database project in my solution and a database imported from windows azure via SSMS "Import data-tier app..." option. When using schema compare, the comparison shows system "service brokers" (message types, queues, etc.) in the delete section. When I apply the update, everything works, but these system service brokers are not deleted and appear again and again.

Unwated items to be deleted

I suppose that it is not possible to delete them, but is there a possiblity to ignore them in the schema compare?


Solution

  • If you click on the settings icon (looks like a cog on the compare tool toolbar) and then navigate to the Object Types tab you should be able to select/deselect the object types you wish to include/ignore in your comparison.

    The icons in the Object Types tab match those in the comparison so it should be pretty easy to ignore what you wish to ignore.