What are the challenges you face when working across database platforms? Take the survey


Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited November 25, 2005 11:05AM in SQL Compare Previous Versions
Hi Sean,

SQL Compare only supports the PRIMARY filegroup. Filegroup support is
still something we've yet to add to SQL Compare.


Brian Donahue
Red Gate Technical Support

"Sean" <sbrockway@mailinator.com> wrote in message
> Does SQL compare support filegroups?
> I'm doing a compare between 2 DBs and one of them has and extra filegroup
> and a file in that group, but SQL compare doesn't seem to catch that
> difference and script it out.


  • Options
    To be more specific, SQL Compare will script the creation of objects into their correct filegroups, provided the 'ignore filegroups' option is not specified.

    SQL Compare does not create filegroups, however. If the filegroup does not exist on the destination server, the script will error unless an administrator manually creates the necessary filegroups before running the synchronization script.
This discussion has been closed.