Wednesday, March 21, 2012 4:12 PM
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.
Friday, March 23, 2012 8:43 AMModerator
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.
TechNet Community Support
- Marked As Answer by Challen FuModerator Thursday, March 29, 2012 9:49 AM
Thursday, April 05, 2012 3:32 PMThanks Challen.