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


SSAS Deployment Utility


SSAS Deployment Utility

Author
Message
Lempster
Lempster
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3265 Visits: 1657
I don't disagree with you in general and that's the way I've worked in the past. I think it is a situation peculiar to my current place of work where everything gets deployed using a one-click approach - a .MSI file that runs all the deployment utilities under the covers. This is probably because there is no DBA (yes, you read that right :w00tSmile and so they want as little manual involvement as possible.

Andrew Notarian (1/30/2014)

At this exact moment I am working on the best way to deal with configuration changes from environment to environment so that the compiled ETL code (i.e. the DTSX files) can remain the same with only the config changes.

If you are using SQL 2012 you can do this using Environments, Environment Variables and Parameters. If you're using 2005/2008 then Package Configurations are the way to go.

Regards
Lempster
Andrew Notarian
Andrew Notarian
Say Hey Kid
Say Hey Kid (699 reputation)Say Hey Kid (699 reputation)Say Hey Kid (699 reputation)Say Hey Kid (699 reputation)Say Hey Kid (699 reputation)Say Hey Kid (699 reputation)Say Hey Kid (699 reputation)Say Hey Kid (699 reputation)

Group: General Forum Members
Points: 699 Visits: 429
MSI makes sense for file & registry updates, but are you running SQL updates that way too? Yikes. It sounds like a nice idea but must take a lot of work.
Lempster
Lempster
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3265 Visits: 1657
Andrew Notarian (1/30/2014)
...Yikes. It sounds like a nice idea but must take a lot of work.

It does. :-)

Edit: changed 'is' to 'does'
sneumersky
sneumersky
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2512 Visits: 487
Dude, I really feel for you getting put through the ringer like that.
Lempster
Lempster
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3265 Visits: 1657
sneumersky (1/30/2014)
Dude, I really feel for you getting put through the ringer like that.

Thanks! :-)

I have to be phlegmatic about it and think that at least I'll learn something along the way.
TheComedian
TheComedian
SSC Veteran
SSC Veteran (241 reputation)SSC Veteran (241 reputation)SSC Veteran (241 reputation)SSC Veteran (241 reputation)SSC Veteran (241 reputation)SSC Veteran (241 reputation)SSC Veteran (241 reputation)SSC Veteran (241 reputation)

Group: General Forum Members
Points: 241 Visits: 510
I've tried using the Deployment Utility (not Wizard but Utility) and it seems that it's a complete dud. I agree with OP that I couldn't get anything to work other than /a or answer mode but that's the same thing as running the Deployment Wizard.

If I try to generate a XMLA script for deployment by using the /o or Output mode, nothing happens. I don't get an error or anything but nothing is generated nor is any feedback given. Here is the command that I'm trying to run:

C:\....>Microsoft.AnalysisServices.Deployment.exe C:\My Documents\Visual Studio 2010\Projects\AdventureWorksProject\MyProject\bin /o C:\DeploymentFile.xmla

As per the instructions on http://technet.microsoft.com/en-us/library/ms162758.aspx :

- Microsoft.AnalysisServices.Deployment.exe= Deployment Utility executable
- C:\My Documents\Visual Studio 2010\Projects\AdventureWorksProject\MyProject\bin = The directory where the .asdatabase is located
- /o C:\DeploymentFile.xmla = output mode and the location and name of the xmla script that I want to generate

I have all four deployment files in the C:\My Documents\Visual Studio 2010\Projects\AdventureWorksProject\MyProject\bin folder. So can anybody answer the following:

1. Am I missing something here? Why isn't the xmla script being generated?

2. If I want to xmla script to point to a target server/database is this possible through the output mode of Deployment Utility? I mean if I change the deploymenttargets file in the bin folder to point to my desired target, say ServerABC and DatabaseXYZ, upon successful running of the Deployment Utility in output mode, will ServerABC and DatabaseXYZ automatically be the targets in the generated XMLA script?

Thanks
Lempster
Lempster
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3265 Visits: 1657
TheComedian (3/31/2014)
I've tried using the Deployment Utility (not Wizard but Utility) and it seems that it's a complete dud. I agree with OP that I couldn't get anything to work other than /a or answer mode but that's the same thing as running the Deployment Wizard.

If I try to generate a XMLA script for deployment by using the /o or Output mode, nothing happens. I don't get an error or anything but nothing is generated nor is any feedback given. Here is the command that I'm trying to run:

C:\....>Microsoft.AnalysisServices.Deployment.exe C:\My Documents\Visual Studio 2010\Projects\AdventureWorksProject\MyProject\bin /o C:\DeploymentFile.xmla

As per the instructions on http://technet.microsoft.com/en-us/library/ms162758.aspx :

- Microsoft.AnalysisServices.Deployment.exe= Deployment Utility executable
- C:\My Documents\Visual Studio 2010\Projects\AdventureWorksProject\MyProject\bin = The directory where the .asdatabase is located
- /o C:\DeploymentFile.xmla = output mode and the location and name of the xmla script that I want to generate

I have all four deployment files in the C:\My Documents\Visual Studio 2010\Projects\AdventureWorksProject\MyProject\bin folder. So can anybody answer the following:

1. Am I missing something here? Why isn't the xmla script being generated?

2. If I want to xmla script to point to a target server/database is this possible through the output mode of Deployment Utility? I mean if I change the deploymenttargets file in the bin folder to point to my desired target, say ServerABC and DatabaseXYZ, upon successful running of the Deployment Utility in output mode, will ServerABC and DatabaseXYZ automatically be the targets in the generated XMLA script?

Thanks

I don't think you are missing anything - it just doesn't work.
Regarding the target server/database, yes, that is my understanding of how it should work.

As you have experienced the same issue, please vote on Connect - the latest from Microsoft is that they were unable to reproduce the issue.

Regards
Lempster
TheComedian
TheComedian
SSC Veteran
SSC Veteran (241 reputation)SSC Veteran (241 reputation)SSC Veteran (241 reputation)SSC Veteran (241 reputation)SSC Veteran (241 reputation)SSC Veteran (241 reputation)SSC Veteran (241 reputation)SSC Veteran (241 reputation)

Group: General Forum Members
Points: 241 Visits: 510
Done; thanks for the reply.

I've talked to some other people and it seems that Deployment Wizard is a lot more popular than Utility; I guess they just don't want to wrestle with it :-).
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