how to move objects to new filegroup

[kodaksmile]

Is there an easy way in sql 2005 to move existing objects to a new filegroup? (I know you can use the create/move data/drop object or if there is a clustered index create the clustered index in the new filegroup but, we have a couple thousand tables alone to move)

 

[ptheriault]

Look up DBCC SHRINKFILE with the emptyfile option.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[kodaksmile]

That only allows you to move data to another file in the same filegroup - I need to move all user objects to a new file group.