How can we help you today? How can we help you today?

DB deployment dropping the user

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?

Thanksglqg6qr8n8sm.png
5t03158o4upz.png


Ravin
0

Comments

3 comments

Sort by
  • 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).
    AlessandroAlpi
    0
  • 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
    Ravin
    0
  • 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.
    AlessandroAlpi
    0

Add comment

Please sign in to leave a comment.