Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSAS Deployment through Deployment Script


SSAS Deployment through Deployment Script

Author
Message
mauryakamal
mauryakamal
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
Points: 32 Visits: 191
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
Arun Sathianathan
Arun Sathianathan
SSC-Addicted
SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)

Group: General Forum Members
Points: 494 Visits: 506
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.
mauryakamal
mauryakamal
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
Points: 32 Visits: 191
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.
Arun Sathianathan
Arun Sathianathan
SSC-Addicted
SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)

Group: General Forum Members
Points: 494 Visits: 506
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.
mauryakamal
mauryakamal
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
Points: 32 Visits: 191
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
Arun Sathianathan
Arun Sathianathan
SSC-Addicted
SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)SSC-Addicted (494 reputation)

Group: General Forum Members
Points: 494 Visits: 506
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.
namrata773
namrata773
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 38
What does the copy to output directory property do? what is the source file that it copies to the output directory??
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