Idera SQL Schema Compare allows you to compare and synchronize database filegroups including the filegroup data files. Database log files are not supported.

Comparing filegroups is similar to other database objects. You start by selecting the Filegroups option in the Comparison Options Database Objects window:

When the filegroup option is selected, a filegroup category appears in the comparison grid. The plus sign adjacent to the filegroup allows you to view the data files associated with the filegroup.

When you choose to synchronize the database filegroups, it is important to remember that the path of the physical file mapped to the data files must exist on the target system. If this is not the case, you can change the path and filename of the data file in the comparison grid as follows:

You can also exclude filegroups or specific data files, similar to other database objects. Excluded items will not be synchronized.

The following restrictions apply to filegroup synchronization:

 |    |  |   |   |