InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 10:01:01 GMT20http://www.sqlservercentral.com/Forums/Topic1405464-17-1.aspxSolution from www.ssas-info.com:When you have BIDS helper installed, it's possible to deploy the aggregations only. There is a button in the partitions tab.However it's not possible to create a script to deploy only the aggregations.grts,Eric.Wed, 16 Jan 2013 01:45:23 GMTaardedhttp://www.sqlservercentral.com/Forums/Topic1405464-17-1.aspxHi,I'm using SQL server 2008 R2.Monthly a job creates new 'month' partitions. So this partitions are not in my BIDS project.Now I have created some 'usage based aggregations', and want to deloy them.My problem:When I deploy them with 'Retain partitions' the new aggregations are not deployedWhen I deploy them without 'Retain partitions' checked, my job-create partitions are gone.What is the best way to deploy the Aggregations, without losing my partitions?Thanks for any suggestions.Thu, 10 Jan 2013 07:51:57 GMTaarded