There is a bug in TableColumnFilterRule.cs ( SqlPackageFilter=KeepTableColumns(Employees) ). When generated change script starts from PredicateSetStatement (i.e. SET ANSI_NULLS ) instead of AlterTableDropTableElementStatement, the filter is ignored. As a result, the columns getting dropped when the expected behavior is that they will remain.
There is a bug in TableColumnFilterRule.cs () instead of AlterTableDropTableElementStatement, the filter is ignored. As a result, the columns getting dropped when the expected behavior is that they will remain.
SqlPackageFilter=KeepTableColumns(Employees)
). When generated change script starts from PredicateSetStatement (i.e. SET ANSI_NULLS