Tuesday, April 07, 2015

Deploying SSAS databases

Deploy AS database to test environment with VS 2012

With Visual Studio 2012 and SQL Server Data Tools 11.1.50318.0

Project configuration Active Solution is set to Development.

From within Visual Studio, right-click on the SSAS project, Select ‘Deploy’ in the dropdown menu.

Deploy AS database to production with Deployment Wizard

Start Analysis Services deployment wizard


Welcome screen – Next


Database file

Browse to the bin folder of your VS2012 Analysis services project and look for the file with the asdatabase extension. Next


Installation target. Enter Server name and Database name as it should appear on that server. Next


Specify Options for partitions and roles. Next


Specify configuration Properties. Check ‘Retain configuration settings for existing objects’.


Select Processing Options. Default processing. Next.


Confirm deployment. Next.

Deployment is done.

No comments: