Roles migration in a cube from one databse to another on same server.

Question

Hello All,

              I have deployed a  Database-A from Test server and removed all the roles ( 40 or so) and made some changes to dims and hierarchies and deployed agian it to test server with  different database name Database-B.

So is there anyway that I can migrate all the roles(40) from Database A to Database B without manually creating all the roles again in B.

Thanks

Shilpa.

---

SR

Answer 1

Hi Shilpa,

The correct step is creating different roles in BIDS while develop the project, then no matter which database you deploy the roles will be deployed to the database, all the existed roles in SSMS will also be overrided within the same database. To your scenario, I think you might create the roles later via SSMS, right? to this scenario, It appear to me that there is no better solution, you can create the script to different roles, then execute the script after replace the database name using the new database in the script. This will also cost you some time, so the better solution to create the roles in the BIDS.

Thanks,

---

Challen Fu

TechNet Community Support

Answer 2

Thanks Challen.

---

SR