AMO: Merging Partitions

Does anybody have a sample AMO code for merging two existing partitions through AMO? Please help.

Thanks,

Nagy

Copied from http://technet.microsoft.com/en-us/library/ms345091.aspx

Merging Partitions

Merging partitions means performing any operation that results in two or more partitions becoming one partition.

Merging partitions is a method of the Partition object. This command merges the data of one or more source partitions into a target partition and deletes the source partitions.

Partitions can be merged only if they meet all the following criteria:

Partitions are in the same measure group.
Partitions are stored in the same mode (MOLAP, HOLAP, and ROLAP).
Partitions reside on the same server; remote partitions can be merged if on the same server.
|||

Thanks for your reply Adrian. This merges all the partitions in a measure group into one. What is the code to merge Partition_a with Partition_b when my measure group has Partition_a, Partition_b, Partition_c, Partition_d?

Regards,

Nagy

|||

If you want to merge A and B into A, create an array of size 1 with B and call Merge on partition A with that array.

The Merge method will merge the specified collection of Partitions (the sources) into the Partition on which is called (the destination).

Adrian Dumitrascu