I have a problem with Amazon RDS SQL Server (2014) and trying to use it with Visual Studio SQL Server Data Tools, and there's not much in the way of help on the AWS support site.
I have run up an instance of RDS with and accessed it with SQL Management Studio with no problems. I create a database and then run a schema compare from SSDT and hit update.
The first thing the update process does is amends the db_owner authorisation which then completely locks out the master user from the database on RDS. The change is identified when you hit compare in SSDT, but there is no way of turning it off that I can see.
Can anyone tell me a way around the problem?
On the SchemaCompareProject page click on the sttings icon and go to the Object Types tab. Within the Application-scoped list there is an option for Role Memberships.
Uncheck this and re-run the compare - the line item forcing the change of authorisation disappears. This keeps rdsa as the db_owner and everything syncs correctly.