Overlay a Copy of one DB structure to Staging DB in SSAS Server

Hi Gicks,

How to Overlay a copy of one DB structure to Staging DB structure in SSAS Server ? (Both DBs are in SSAS)

Regards
Rave
Ravee123Asked:
Who is Participating?
 
ValentinoVBI ConsultantCommented:
Are you asking how you should take the OLAP database schema on the Development environment and deploy it to Staging?

One possibility is this: use SSMS to connect to your SSAS instance, locate your database, right-click and select Script Database As > ALTER To > New query editor window.  When that action completes, you'll have an XMLA script to deploy your changes.
(note that this will take a while with larger OLAP DBs)

Another option, giving you more control over what the XMLA script will do, is using the Analysis Services Deployment Wizard.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.