I have scoured the internet but cannot find a definitive answer. I need to copy the users/roles and object level permissions from database A to database B. Both databases are on the same SQL Server 2014 instance.
I am using SQL Server Data Tools for Visual Studio 2013. I dropped the "Transfer SQL Server Objects Task" component on to the Control Flow and changed the properties under Security for CopyDatabaseUsers, CopyDatabaseRoles and CopyObjectLevelPermissions to True.
After executing the task, the users and roles are copied as expected however none of the object level permissions were copied.
I found a link to this connect item from 2011:https://connect.microsoft.com/SQLServer/feedback/details/676875/transfer-sql-server-objects-task-database-role-membership
This issue was reported and Microsoft acknowledged the issue and stated it would not be fixed in that version. Since several SQL versions have been released since 2011 I'd like to know if this feature is still officially broken.
Does anyone know of a current status from Microsoft? If this is still a bug, is there an open connect item or should I create a new one?
I appreciate any new information you may have.