dbTalk Databases Forums  

Migrate roles with xmla

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Migrate roles with xmla in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
hummel
 
Posts: n/a

Default Migrate roles with xmla - 10-11-2010 , 08:33 AM






I have a Analysis Services 2008 project that I distribute to client
servers with xmla. On the client site I add roles and memebers to the
cubes (maually)

I could not find a way to script those roles to xmla after entering
them manually.

This is necessary when I send an update of the project (complete
xmla). As the roles depend on the customer and the local AD I cannot
prepare the roles in my big xmla.

What I would like to do is something like:
Quote:
export all existing roles/memberships/dimension sequrities to xmla (on the customer site)
replace the entire project (run big xmla)
import xmla with roles/memberships/dimension
I tried to skript the roles structure with the management studio. It
never gives me the complete xmla - only the part of the node. I would
have to export lots of xmla.

Any ideas?

Thanks!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.