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.
