We help IT Professionals succeed at work.

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)

Watch Question

BI Consultant
Most Valuable Expert 2011
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.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.