Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2012-03-09
1
Medium Priority
?
330 Views
Last Modified: 2016-02-14
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
Comment
Question by:Ravee123
1 Comment
 
LVL 37

Accepted Solution

by:
ValentinoV earned 1500 total points
ID: 37713521
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question