DB deployment dropping the user

Ravin

When I try to deploy the database using bamboo server it is dropping the user eventhough I checked the Users permissions and role membership and unchecked the users in filters.

I followed the steps as it says in the following link
https://documentation.red-gate.com/display/SR1/Deploying+a+database+using+Bamboo

Could any one help me please?

Thanks

AlessandroAlpi

Hi @Ravin,
what do you mean with "when I try to deploy"?
what are you using for deploying your db? The image you posted belongs to SQL Source Control (if I get it correctly).

Ravin

Thanks for your reply @AlessandroAlpi

My bad, I wasn't clear in my post. I am using Bamboo server for my build and deployment.

Used DLM Automation addon to build the repository and a shell script to deploy.

I have done the steps as mentioned in this following link https://documentation.red-gate.com/display/SR1/Deploying+a+database+using+Bamboo

Thanks

AlessandroAlpi

Hi @Ravin,

The first picture, depicts the filter settings, and you've removed the users. The second picture, if I remember well, it's about the database comparison options file (described here).

Could you please check how the users are filtered in the filter.scpf file? You can find it into your SQL Source Control repository.

I think that the filter file is not configured correctly if you want to include users and roles. You should to check also the Users box.