What are the challenges you face when working across database platforms? Take the survey
Options

Filter out object names for publisher subscriber comparisons

DennisPostDennisPost Posts: 6
edited September 22, 2016 6:43AM in SQL Compare
I'm comparing the differences be publishers and subscribers.
It there any way to filter out all the replication SPs?

Project options only has:
Ignore NOT FOR REPLICATION
Ignore replication triggers

Was hoping there would be WHERE SPName NOT LIKE 'sp_MS%'

Would be great if this was extra source option : Publication name
Only the subscribers would be in the target dropdown. Even better loop through all subscribers option.

Cheers,
Dennis

Comments

  • Options
    Hi Dennis,

    I think custom filters could help you here. If you click on "Custom filter rules..." in the left hand pane of your project you ought to be able to add a filter for stored procedures to:
    Exclude if: Object name Begins with sp_MS
    which I think should do what you are looking for.

    I hope that's useful,

    Matthew Chandler
    Software Developer on SQL Compare and SQL Data Compare
    Matthew Chandler
    Software Developer on SQL Compare and SQL Data Compare
Sign In or Register to comment.