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?