April 7, 2009 at 6:15 am
We have four file in SSAS bin directory i.e.
XMLA file
.asdatabase
.deploymenttargets
.configsettings
.deploymentoptions
How to deploy on SSAS production server by using the above files.
Regards,
kamal maurya
April 7, 2009 at 6:57 am
Check out Analysis Services deployment wizard in BOL : http://msdn.microsoft.com/en-us/library/ms176121.aspx.
I also use ASCMD in a batch file to release the XMLA scripts into prod environment.
April 7, 2009 at 8:56 am
Thanks for your comment . I gone through the given msdn link but could not find how to deploy the XMLA scripts file to production server.
Can you please elaborate on this.
April 7, 2009 at 9:55 am
After you create a SSAS project and build it using BIDS, you will get the list of the files that you have mentioned. Then use Analysis Services deployment (wizard or command line utility :http://msdn.microsoft.com/en-us/library/ms162758(SQL.90).aspx ) that will take these files as input and will deploy the cube to the server that you specify.
You can alternatively use the wizard to create XMLA file and then execute it using SSMS or using ascmd utility from command line.
April 7, 2009 at 9:55 pm
Thanx for your comment..
We have to run all below three commands in command prompt in three steps and my all four scripts should be in bin directory.
Run Step 1 in command prompt:
Microsoft.AnalysisServices.Deployment.exe
Run Step 2 in command prompt:
:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\bin
Run Step 3 in command prompt:
/s: C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\bin\deployment.log
After running Successfully all three steps one after one my ssas packaGE WILL BE deploy in analysis server.
Please let me know whether is it the correct procedure?
kamal maurya
April 8, 2009 at 4:30 am
Step 1:
Open your SSAS project in IDE and build it. It will generate the following files in bin folder
- YourDB.asdatabase
- YourDB.configsettings
- YourDB.deploymentoptions
- YourDB.deploymenttargets
Step 2:
Run the Analysis Services deployment wizard, speciy the SSAS database to the YourDB.asdatabase file and set the options that you need.
In the confirm deployment option, select "Create deployment script" option and specify a path.
This will create a XMLA file
Step 3:
Now you have 2 options to release the SSAS DB to your production server
option 1 : Connect using SSMS and execute the xmla script.
option 2 : If you want to run it as part of the batch file, use ascmd.exe to release it.
November 13, 2013 at 10:04 pm
What does the copy to output directory property do? what is the source file that it copies to the output directory??
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply