Save Valuable Hours with Analysis Services Deployment Utility Command Line

The Analysis Services Command Line Utility is one of the 5 methods of deploying Analysis Services databases.

ichi, ni, san, yon, go …

http://msdn.microsoft.com/en-us/library/ms175446(v=sql.105).aspx

The deployment wizard is a brilliant piece of work taking the headache out of cube deployments.   However the Next, Next, Next does get tiresome, you will reap the rewards in time and mouse clicks by dishing out some prepared command lines.

A few suggestions on just one approach – the deployment utility …

1. Utilise your project configurations to easily switch deployment settings between environments …

http://www.artisconsulting.com/blogs/greggalloway/Lists/Posts/Post.aspx?ID=14

2. Set your cube’s Data Source and Build the solution.  There is a command line version of a “Build” here …

http://dataonwheels.wordpress.com/2011/06/01/simple-batch-script-to-generate-xmla-and-deploy-ssas-db/

3. Deploy the build with the currently saved data source and project deployment settings and create a log …


<DriveLetter>:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Microsoft.AnalysisServices.Deployment.exe
<DriveLetter>:\Builds\YourSSASFolder\bin
/s: <DriveLetter>:\Builds\YourSSASFolder\your_deployment.log

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s