// Object exclusions migrated from the Redgate project <ProjectFilter>.
var exclusions = new SchemaComparisonExcludedObjectId[] {
// View: (@NAME = 'V_MT')
new(View.TypeClass, new ObjectIdentifier("dbo", "V_MT")),
new(View.TypeClass, new ObjectIdentifier("V_MT")),
new(View.TypeClass, new ObjectIdentifier("dbo.V_MT")),
new(View.TypeClass, new ObjectIdentifier("dbo.[V_MT]")),
new(View.TypeClass, new ObjectIdentifier("[dbo].[V_MT]")),
new(
View.TypeClass, // Object type
new ObjectIdentifier("[dbo].[V_MT]"), // Schema + name
null, // No target type (source-only)
null // No target identifier
),
new(
View.TypeClass, // Object type
new ObjectIdentifier("dbo", "V_MT"), // Schema + name
null, // No target type (source-only)
null // No target identifier
)
};
foreach (var exclusion in exclusions) {
comparison.ExcludedSourceObjects.Add(exclusion);
comparison.ExcludedTargetObjects.Add(exclusion);
}
Steps to Reproduce:
I have one view to ignore that is only in the source database, I tried to ignore it with these lines and not any of them seems to work
Did this occur in prior versions? If not - which version(s) did it work in?
Is is possible to guide me to ignore this view ?
I'll try to apply the solution to Stored procedure that I have to ignore by specific name
(DacFx/SqlPackage/SSMS/Azure Data Studio)