'edit the sql schema compare (.scmp) so that certain tables and stored procs are filtered

Since a few months we are working with a (VS) database solution for our SQL Server objects. Of course, the Schema Compare is a feature we often use.

I've got the question of the team if we can modify the schema compare script (.scmp) so that certain tables and stored procs are excluded from the compare. This script will be part of the solution and used by all team members.

eg. every table with '_BU' (wildcard) in the name. Example: DimCustomer_BU20220419 This means a backup table -> should be excluded

I saw that this is perfectly possible with APEX SQL but I'd rather stay within VS/Devops.

Thanks in advance.

sql-servervisual-studioazure-devopscompare


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions