November 2, 2011 at 2:57 am
Currently, to create a Analysis Server database role, the only way I know is : create a rolw within the Visual Studio of the Analysis Services Project.
However, I am always requested to re-deploy the Analysis Services Project because of bug fixing or user requirements changes.
In that cases, I will need to re-create all the roles within Visual Studio.
Can I :
(1)Initially, I create all the roles within Visual Studio
(2)Then I deploy the project
(3)Open SQL Server Management Studio, and then Analysis Server, and then open the Analysis Server database
(4)Open its Roles, right click one of its role and choose "Script Role as"
Next time, if I am requested to re-deploy the Project, I will not add the Roles within Visual Studio but execute the role script instead.
Does it work ?
Is a role generated by script functionally the same as a role created with Visual Studio ?
November 2, 2011 at 11:44 am
onlo (11/2/2011)
Currently, to create a Analysis Server database role, the only way I know is : create a rolw within the Visual Studio of the Analysis Services Project.However, I am always requested to re-deploy the Analysis Services Project because of bug fixing or user requirements changes.
In that cases, I will need to re-create all the roles within Visual Studio.
Can I :
(1)Initially, I create all the roles within Visual Studio
(2)Then I deploy the project
(3)Open SQL Server Management Studio, and then Analysis Server, and then open the Analysis Server database
(4)Open its Roles, right click one of its role and choose "Script Role as"
Next time, if I am requested to re-deploy the Project, I will not add the Roles within Visual Studio but execute the role script instead.
Does it work ?
Is a role generated by script functionally the same as a role created with Visual Studio ?
Yes, the Analysis Services Deplyoyment Wizard will give you various options...including the creation of a script that can be scheduled or executed in future. As far as I know, one of the options also allow you to leave roles intact.
See the following: http://msdn.microsoft.com/en-us/library/ms174817.aspx
Hope this helps.
Martin.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply