I'm using SQL Source Control and the SQL Change Automation PowerShell cmdlets to set up build pipelines for many databases. For 99% of the DBs, it works great. However, with one specific DB I have a unique requirement and I can't find authoritative documentation about how to resolve it.
One of the databases includes thousands of tables called "tmp_<GUID>". I want to filter these out. That's easy enough with a filter to exclude any tables prefixed with "tmp_".
However, in amongst those tables are about a dozen tables called "tmp_something_specific". I think these tables are probably important so I'd like to include them. (For the record, I am not responsible for dev/architecture etc and would ideally like to avoid opening that pandoras box for the time being.)
What I want is a filter that does something like:
EXCLUDE objects that start with "tmp_"
EXCEPT:
INCLUDE object that equal "tmp_specific1", "tmp_specific2" or "tmp_specific3"
These filters contradict each other, so I want to understand how SQL Compare will decide which rule takes precedence.
Is there any documentation about filter precedence? I can't find any. If not, could someone please explain how SQL Compare will decide which filter rule will win?
Thanks in advance!
Hi Alex,
One of the databases includes thousands of tables called "tmp_<GUID>". I want to filter these out. That's easy enough with a filter to exclude any tables prefixed with "tmp_".
However, in amongst those tables are about a dozen tables called "tmp_something_specific". I think these tables are probably important so I'd like to include them. (For the record, I am not responsible for dev/architecture etc and would ideally like to avoid opening that pandoras box for the time being.)
What I want is a filter that does something like:
EXCLUDE objects that start with "tmp_"
EXCEPT:
INCLUDE object that equal "tmp_specific1", "tmp_specific2" or "tmp_specific3"
These filters contradict each other, so I want to understand how SQL Compare will decide which rule takes precedence.
Is there any documentation about filter precedence? I can't find any. If not, could someone please explain how SQL Compare will decide which filter rule will win?
Thanks in advance!