Alter table switch partition to another filegroup of another table

Question

Is it possible to use "Alter table switch partition......." to move the partition to another other table which in different filegroup from the source table ?

Answer 1

You cannot directly switch a partition from the partitioned table to a table in a different file group, but you can do it indirectly.

1. Create a table (named SourceTemp) with the same structure as the partitioned table on the same filegroup
2. Switch the partition from the partitioned table to the table SourceTemp on the same filegroup
3. Export data from the table SourceTemp to the destination table on another file group.
4. Drop the table SourceTemp

Answer 2

If you read the topic for ALTER TABLE, you will find this sentence: Both the source table or partition, and the target table or partition, must be located in the same filegroup.