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.
| 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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
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. |
|
|
|
learntsql
524 Posts |
Posted - 2014-02-20 : 01:15:32
|
| Hi All,Any update please.TIA |
|
|
|
|
|
|
Deploying the SSAS solution