Moving SQL table definitions, but the partition definition is different

I'm creating a SQL datamart archive that has a handful of tables that are partitioned. The table definition will be tracked so that changes are moved over, but I want to exclude the partition definition as the archive partition definition will be different.

The partition function, schema definition and even the date column on which the partition is acted will be different.


Is there a way at I can exclude the partition definition from the comparison, so that only column changes are migrated?

Parents Reply Children