Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Deply aggregations Expand / Collapse
Author
Message
Posted Thursday, January 10, 2013 7:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 14, 2014 5:58 AM
Points: 37, Visits: 290
Hi,

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 deployed
When 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.



Post #1405464
Posted Wednesday, January 16, 2013 1:45 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 14, 2014 5:58 AM
Points: 37, Visits: 290
Solution 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.



Post #1407674
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse