• Article

Manage Partition Wizard (Select Staging Table Options Page)

Use the Select the Staging Table Options page to create the staging table you want to use for switching your partitioned data.

Staging tables must reside in the same filegroup of the selected partition where the source table is located. The staging table must mirror the design of both the source table and the destination table. For more information on partition switching, see Transferring Data Efficiently by Using Partition Switching.

You can also create the same indexes in the staging table that exist in the source partition. The staging table automatically contains a constraint based on the elements of the source partition. This constraint is typically generated from the boundary value of the source partition. For more information on switching partitions with indexes, see Partition Switching When Indexed Views Are Defined.

  • Staging table name
    Create a name for the staging table or accept the default name displayed in the edit box.

  • Switch partition
    Select the source partition that you want to switch out of the current table.

  • New boundary value
    Select or enter the boundary value you want for the partition in the staging table.