• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 334
  • Last Modified:

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
0
Ravee123
Asked:
Ravee123
1 Solution
 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now