How can we help you today? How can we help you today?

filegroups

Hi Sean,

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

Regards,

Brian Donahue
Red Gate Technical Support

"Sean" <sbrockway@mailinator.com> wrote in message
news:4f6MBdgMEHA.1508@server53...
> 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 Donahue
0

Comments

1 comment

Sort by
  • Brian Donahue
    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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.