Page History
...
While this could work in most of the cases, there are scenarios in which you might want to keep the filegroup unchanged when transferring objects between the DB_1
and the DB_2
databases. You can achieve this by creating a mapping for the filegroups FG_1
and FG_2
. When a mapping exist, the comparison and scripting of the Employees table changes as follows:
FG_1
andFG_2
are considered equivalent, which means that no schema difference is triggered by the filegroup clause of the Employees table.- If other schema differences require the Employees table to be synchronized, it will be created on the "mapped" filegroup, not the original one.
Working with filegroup mappings
...