• Article

Manage Partition Wizard (Select Partition Action Page)

Use the Select Partition Action page to choose the action you want to perform on your partition.

Create a Staging Table

Partition switching is a common partitioning task if you have a partitioned table that you migrate data into and out of on a regular basis; for example, you have a partitioned table that stores current quarterly data, and you must move in new data and archive older data at the end of each quarter.

The wizard designs the staging table with the same partitioning column, table and column structure, and indexes, and stores the new table in the filegroup where your source partition is located.

To create a staging table to switch in or switch out partition data, select Create a staging table for partition switching.

Sliding Window Scenario

To manage your partitions in a sliding-window scenario, select Manage partitioned data in a sliding window scenario.

  • Create a staging table for partition switching
    Creates a staging table for the data you are switching in or switching out of the existing partitioned table.

  • Manage partitioned data in a sliding window scenario
    Appends an empty partition to the existing table that can be used for switching in data. The wizard currently supports switching into the last partition and switching out the first partition.