During development the project is focus on schema and schema changes and test
security. When I I deploy the database to production, I end getting
the development security in the production database. How does one create
a script that recreates the security in the production environment so that I can
be reused it after the deployment. The synchronziation wizard is not appropriate
since it moves data as well.
After deploying a Business Intelligence project how to recreate the OLAP security
pure159112
Lisurc
In SQL Server Management Studio you can access Script related menu commands from the context menu. All management dialogs in that program also have Script button on the toolbar. An object can be scripted and script re-executed on another server.
Additionally you can import entire database as a BI Development project using. In BI Development Studio - menu File | New | Project and choose the project of type "Import Analysis Services 9.0 Database". That imported solution can be adjusted and deployed onto another server.
bw12117
I not sure what is meant by context senstive menus I was hoping for a faster method.
I know that what I ending up doing was for each role in the production database Roles Heading:
I right clicked on the properties of the role and then selected the "Cubes" page and then clicked the Script Action menu.
This took 3 hours to do for all of the production roles:
I am not sure I understand the second choice since I did this at the beginning of the project, removed all of the
production security, made hundreds of changes to cubes and dimensions and readded the development security interactively.