How to migrate existing indexes to a different file group?

[mssqlforum]

Is there any utility to migrate the existing indexes on default filegroup to a new user defined file group? The only way that I know is to delete the index and recreate with new filegroup.

How about for table? Is there any utility for migrating the existing tables to a different filegroup? The only way that I know is to create a clustered index on the new filegroup which will move the table to the new filegroup. If a clustered index exists then drop the clustered index and recreate it with the new filegroup

I am looking for an existing utility which would do the above?

Any help is appreciated.

Thanx in advance.

[rmiao]

You can move table in em.

[mssqlforum]

thx

[mssqlforum]

thx

[rmiao]

Not as I aware other than recreate clustered index on new filegroup.