Is it possible to use a database VIEW or UDF to define "Custom filter rules"?

For SQL Compare, we need to exclude many custom tables and code objects. We can't always name them in a boiler plate fashion that allows exclusion based on name. I'd like to exclude objects based on a set returned by a view or udf. Is this possible now? If not, is it being considered for a future version?
Tagged:

Best Answer

  • Sergio RSergio R Posts: 610 Rose Gold 5
    This is not possible directly on the tool

    You might be able to find a way to export the query result to an xml file in a format that SQL Compare will recognize as a filter file.

    Currently we are not planning to change this behavior, but if you wish you can suggest this as an idea on our user feedback forum: https://redgate.uservoice.com/forums/141379-sql-compare

    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.