Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 340
  • 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
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.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

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