SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Deply aggregations


Deply aggregations

Author
Message
aarded
aarded
SSC Veteran
SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)

Group: General Forum Members
Points: 284 Visits: 314
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.



aarded
aarded
SSC Veteran
SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)

Group: General Forum Members
Points: 284 Visits: 314
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.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search