March 31, 2014 at 8:01 am
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
April 1, 2014 at 7:28 am
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
April 1, 2014 at 8:52 am
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 :-).
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply