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

Scripts to synchronize indexes are not using filegroup

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited June 23, 2004 8:39AM in SQL Compare Previous Versions
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?


Brian Donahue
Red Gate Technical Support

"Stephane Leduc" <sleduc@cisco.com> wrote in message
> Hello,
> I'm using SQL Compare to synchronize a table on 2 servers, where one
> 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
> 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
This discussion has been closed.