Filtering DLM Dashboard
Andye
Posts: 6
Brand new to Redgate so this question may be just not reading.
Having established DLM and connected to a database I have found a number of unnecessary tables being checked.
I wanted to filter these out.
I read and re-read the section of the manual describing this process and the part that has me confused is this.
There's an alternate and detailed description of hand editing a .scpf file.
So based on this description I tried creating a filter in SQL Source Control, which I did successfully through a well laid out wizard.
Having completed this process is DLM now filtered? It seems not as I'm still getting schema drift warnings via DLM for the objects in the SSC filter.
Do I export the filter created in SSC to a .scpf file? If so, how?
Thanks
Andrew
Having established DLM and connected to a database I have found a number of unnecessary tables being checked.
I wanted to filter these out.
I read and re-read the section of the manual describing this process and the part that has me confused is this.
I'm not sure of a number of things here.Create a filter in SQL Compare or SQL Source Control
DLM Dashboard supports filters created using SQL Compare or SQL Source Control:* to create filters using SQL Compare, see Using filters * to create filters using SQL Source Control, see Using filters to exclude objects
There's an alternate and detailed description of hand editing a .scpf file.
So based on this description I tried creating a filter in SQL Source Control, which I did successfully through a well laid out wizard.
Having completed this process is DLM now filtered? It seems not as I'm still getting schema drift warnings via DLM for the objects in the SSC filter.
Do I export the filter created in SSC to a .scpf file? If so, how?
Thanks
Andrew
Comments
To filter in DLM Dashboard you need to go to the Pipeline view and click on the "Filter objects..." link on the right hand side of the screen. You'll then be able to upload the filter file for DLM Dashboard to use.
If you've committed a filter to your repository in SQL Source Control, you'll need to retrieve the Filter.spcf file that is now in your repository and use this filter file file in DLM Dashboard.
Redgate Software
Thanks for the reply Robert.
I'm clear on the application of the filter my question relates to gettinggenerating the .spcf file itself.
I'm using the "evaluation repository". How do I retrieve the spcf file from this repository?
regards
Andrew
In that case, probably the easiest thing to do would be to go to the Setup tab in SQL Source Control, then find the "Under the hood" section and click on "Show". Click on the button labelled "Open working base" and you'll find the filter file in the directory that is opened.
Redgate Software