Migrate index filegroups

  1. From the main menu, select Compile > Index Filegroup Migration.

    The Index Filegroup Migration View lists all compiled indexes and their properties.

  2. Review the information in the Index Filegroup Migration View.
    Index Count

    The number of indexes that will be migrated is listed at the top of the table.

    Note: 

    The indexes to be migrated are highlighted in red.

    Catalog

    This is the catalog where the index belongs.

    Object Name

    This is the name of the index parent object.

    Index Name

    This is the index name.

    Clustered

    If checked, the index is clustered.

    Current Filegroup

    This is the current index filegroup in SQL.

    Index Filegroup

    This is the destination filegroup.

    This setting can be modified in System Connections. Creating System Connections

    Click Next.

  3. On the Index Filegroup Migration Processing, click Finish.