Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Deploying the SSAS solution

Author  Topic 

learntsql

524 Posts

Posted - 2014-02-18 : 00:49:06
Hi All,

I am new to SSAS area and i am started supporting one of the applications.

I recently did some of the changes for production cube in dev environment and tested.
Now i want to move these changes to Production.

Can some one tell me what approach we can follow to move the changes into production.
The changes are not major, just added some dimensions.

In my dev environment i deployed the solution by right clicking on the solution and changed the server name and database name.

I heard that instead of deploying we can do the changes directly in the production model file.
But i am not sure on this.If we can do the changes how to deploy and process it.

As this is the production move i want ot be sure to avoid the mistakes.

Please guide me on this.
Thanks in advance.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-02-18 : 13:34:14
if you have directly access to production server you can open production model inside BIDS itself by choosing option Open-> Analysis Services Database and giving server and project name. Another way is to script out changes done from dev by using Deployment Wizard and creating corresponding scripts for production environment. then you (or someone with access) can connect to production Analysis server from SSMS open a XMLA window and run the script to reflect changes in production cube.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

learntsql

524 Posts

Posted - 2014-02-19 : 00:25:49
Thank you Visakh for the reply.

In the first approach
"open production model inside BIDS itself by choosing option Open-> Analysis Services Database and giving server and project name."

In this approach should i again do the changes which i did in the Dev environment.
After doing the changes how to deploy/process this changes to production, where i already have the cube deployed in Analysis server.
I mean should i right click on the solution and change the Server and database details and then deploy or do we have any other way to do it.

Thanks in advance.
Go to Top of Page

learntsql

524 Posts

Posted - 2014-02-20 : 01:15:32
Hi All,

Any update please.
TIA
Go to Top of Page
   

- Advertisement -