SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Deploying the SSAS solution
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

learntsql
Aged Yak Warrior

India
514 Posts

Posted - 02/18/2014 :  00:49:06  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 02/18/2014 :  13:34:14  Show Profile  Reply with Quote
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
Aged Yak Warrior

India
514 Posts

Posted - 02/19/2014 :  00:25:49  Show Profile  Reply with Quote
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
Aged Yak Warrior

India
514 Posts

Posted - 02/20/2014 :  01:15:32  Show Profile  Reply with Quote
Hi All,

Any update please.
TIA
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000