How can we help you today? How can we help you today?

Filter out object names for publisher subscriber comparisons

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
DennisPost
0

Comments

1 comment

Sort by
  • mattchandler
    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
    mattchandler
    0

Add comment

Please sign in to leave a comment.