We have separate SQL Server service accounts for each environment. For example, saSQL01prod and saSQL01test and saSQL01dev. We want to ensure that the same permissions in PROD exist in TEST. However, now, SQL Compare wants us to create the saSQL01prod account and remove the saSQL01test account to equalize.

What we wish to happen is that it compare the permissions of the saSQL01prod account in our PROD environment to the saSQL01test account in our TEST environment and generate the compare based off that.

For example, saSQL01prod has dbDataReader in the [db1] database. saSQL01test does not. We want SQL Compare to generate a script to apply the PROD permissions but using the TEST user account and end up with the saSQL01test user having the same permissions to the [db1] database in TEST as the saSQL01prod user has in PROD.

Clear as mud???