Brian DonahueBrian Donahue Posts: 6,590 New member
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" <[email protected]> wrote in message
news:[email protected]
> 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.


  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.