Scripts to synchronize indexes are not using filegroup

Brian Donahue

Hi Stephane,

SQL Compare supports filegroups. It will script the changes to your
index, but it will not actually create a filegroup on your server if it
doesn't exist. The only exception to the rule is if you've turned on the
'Ignore filegroups' option.

Can you please check on that?

Thanks!

Brian Donahue
Red Gate Technical Support


"Stephane Leduc" <sleduc@cisco.com> wrote in message
news:bHac%23m7VEHA.1492@server53...
> Hello,
>
> I'm using SQL Compare to synchronize a table on 2 servers, where one
of
> the server is missing some indexes. I generate the script from the tool,
> but it does not include the filegroup portion of the index present on the
> originating server (The index is defined on a separate filegroup of the
> database).
>
> For example, if I script the object from Query Analyzer, I'm getting
>
> CREATE INDEX [IX_tstmachine] ON [dbo].[tst]([machine], [rectime]) WITH
> FILLFACTOR = 80 ON [AFILEGROUP]
>
> But from SQL Compare, I'm getting :
>
> CREATE NONCLUSTERED INDEX [IX_tstmachine] ON [dbo].[tst] ([machine],
> [rectime])
>
> Note both the FILLFACTOR and the "ON [AFILEGROUP]" are missing!
>
> Is there an option to set to get the proper script, or it's just something
> missing in the tool?
>
> Thanks,
>
> Stephane Leduc
>
>
>
>