File group support?

MichaelW

I found SQL Compare very useful over the last couple of years; however I recently separated a few targeted indexes and tables into their own filegroups only to find filegroups are not considered in the compare. Is there a step I am missing or is there plans to support filegroups?

Michelle T

There is an option to turn on filegroup support - go to the Options tab in the Project Configuration dialog and turn off 'Ignore Filegroups, Partitoin Schemes and Partition Functions'. This will allow you to compare and synchronize filegroup information.

This option is on by default (i.e. we ignore filegroup information by default) because while we attempt to synchronize 'ON' clauses, partitioning information etc, we don't synchronize actual filegroups (because we don't know what the filesystem is like on the target machine and don't want to arbitarily create files on it), so if you plan to synchronize your filegroup information you'll have to make sure any filegroups you're using are available in the target database before you perform the synchronization.