how do I compare only stored procedures

jrbrown00

I need to compare 10-30 stored procedures. They have the same names on the 'prod' and 'test' servers. How do I limit the compare. I am using version 13.1.11.5591 of SQL Data Compare

AlessandroAlpi

hi @jrbrown00,
did you mean SQL Compare (not SQL Data Compare)?
anyway, you can exclude objects using filters: https://www.red-gate.com/hub/product-learning/sql-compare/sql-compare-custom-filters

hope this helps

jrbrown00

So we do not have the correct product. That does answer the question. Thank you.