- Restore the bacpac into SQL using the 'Import Data-tier Application' option.
- Then run the following query against the data in SQL:
ALTER AUTHORIZATION ON ROLE::[db_execute] TO [dbo] - Then run the following query against the data in SQL:
exec sp_dropuser 'MMSAdmin'
exec sp_dropuser 'MMSUser'
exec sp_dropuser 'MMSReader' The final step is to remove the following users if present - MMSReader, MMSuser & MMSAdmin. You can do this as follows: - Within Databases in SQL Server management Studio drill down on the database in question, then drill down Security, then Users.
- For each of the users listed above right click and then click Delete.
You can now Export the data by right clicking the database, click Tasks, then Export Data-tier- Application. The exported bacpac file can then be uploaded to Sage Provisioning Portal. [BCB:180:Andy Footer:ECB] |