Filter out object names for publisher subscriber comparisons
DennisPost
Posts: 6
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
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
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
Software Developer on SQL Compare and SQL Data Compare