Moving data by moving partitions

• David Kranes

  SSCrazy

  Points: 2523

  More actions

  April 18, 2006 at 10:20 am

  #169047

  Hello, is it efficient to move data from one partitioned table to another by moving a partition?  Can DML activities be going on during this operation?  What are the commands to actually do this in SQLServer 2005.  Thank you.

  David

  Best Regards,

  ~David

• Rick Heiges

  SSChasing Mays

  Points: 660

  More actions

  April 19, 2006 at 7:59 am

  #633056

  Yes it is efficient to move data from one partition of TableA to an empty partition on TableB.  Both Partitions must be on the same Filegroup AND the "range" from the Partition from Table A must match or "fit" into the targeted empty partition in TableB.  There are some other restrictions that you may want to look at on BOL.

  ALTER TABLE dbo.TableA SWITCH PARTITION 1 TO dbo.TableB PARTITION 1 ;