Report Portal

AMO - Delete All Partitions From a Database

From time to time I'll need to recreate the dev/beta environment and I have to do that from production. I want an exact copy of production minus all the partitions that have been created with the exception of the template partitions.

At first I would go in and change the XMLA script manually to remove those partitions. However, if there were a lot of measuregroups (50-100), this could take upwards of an hour. Being that it was such a pain I probably didn't keep dev and beta as up-to-date as I should have.

An Analysis Services Stored Procedure is perfect to handle this task. Works beautifully and what took me an hour to do before now takes 30 seconds.

Read more...

Tags: partition, amo

 

2007-2015 VidasSoft Systems Inc.