Synchronize two SSAS databases

Question

Hi

I have 9 cubes in production server. Now i have made huge changes to all 9 cube and have 9 cubes uses shared dim in single solution and tested on dev server and works perfectly with all changes the only concern is that all 9 cubes takes approxmatly 60-70 hours of processing (including Dim and Cube) when i do paralle process and business does not want to down time of 60-70 hours for production server.

could any one adivce how can i go with this big change to production server which should not effect business and also like to move changes to production server.

one thing i had on my mind is to run new cube changes on dev server with a mirror copy production database and make sync with production SSAS database and eventually move the dev one to production server . please advice on this move or suggest any other best alternative approch.

regards

srinivas

Answer 1

synchronizatin database is good option to synchronize two different databases becuase during the synchronization user can query the old cube and after the synchronization is finsish new cueb is up automatically.

http://msdn.microsoft.com/en-us/library/ms174928.aspx

and another way you can create new OLAP database on production server and after the completion of process test it and take the backup of old database and rename the new database which is also good and safe option.

Thanks,

Zaim Raza.

Answer 2

Hi Zaim

thanks for your reply.

In second option if we create new OLAP database on production server and process dim and cubes continuesly for 60-70 hours will it degrade the server performance i.e will it effect other OLAP database querying. like when we are processing new OLAP data base and users are trying to browse old OLAP database and they are facing some performance issuses like slowdown of data browsing and any other impacts .

regards

srinivas

Answer 3

yes, it will degrade the server performance.if there are too much load on your prod server then i will recommend you to process(create) the cube on uat or dev server using live data source and restore it on prod server which is the best way to overcome the live performance issue.

thanks,

Zaim Raza.

Answer 4

Thank you, will try that.