SSMS plugin does not put filter files in the database packages at the moment. Filter rules can still be applied during database deployment to skip/include database objects for comparison. There are two ways to do this:
- If you are using sqlCI
to generate database packages, you can put a filter file by the name 'Filter.scpf' in the top level Scripts/ folder before using sqlCI to generate the package. These filter rules will then be applied when you deploy this package with Deployment Manager.
- If you don't use sqlCI.exe, There is another way of doing this. You can extract the database using Nuget Package explorer
and manually edit it. You need to drop 'Filter.scpf' in all folders which contain state
in their name, for e.g. dbState, dbVersionUpgradeState etc. Once you're done editing it, save it and deploy!