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

SSAS 2008 R2 Deployment from Visual Studio 2008 Expand / Collapse
Author
Message
Posted Monday, October 29, 2012 7:27 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 9:02 AM
Points: 29, Visits: 152
When regularly deploying an Analysis Services project from Visual Studio to Analysis Services 2008 R2, the database must frequently be overwritten - on almost any change.

The 'XXX' database on 'XXX' has changed since the last time the project was deployed. If you proceed with deployment, the database will be overwritten.
Would you like to continue?

What is the resolution for this issue?
Post #1378532
Posted Tuesday, October 30, 2012 4:14 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:48 AM
Points: 13,261, Visits: 10,138
Clicking Yes?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1378652
Posted Tuesday, October 30, 2012 4:18 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:09 AM
Points: 870, Visits: 2,385
It depends, if you install BIDSHelper you can just deploy any calculated measures that you've added without the hassel of having to got through a full deployment.

The other option is to set the Deploy Changes Only Option, but I think you still get the message, and need to process the cube after deployment.


_________________________________________________________________________
SSC Guide to Posting and Best Practices
Post #1378657
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse