Dynamic Database Deployment Security Objects

Automated deployment for web applications and databases

Moderators: Mike Upton, justin.caldicott, Sean.newham, csmith, chirayu, DavidSimner, david.conlin

Dynamic Database Deployment Security Objects

Postby amaher » Thu Aug 29, 2013 4:20 pm

When doing a dynamic database deployment any user role assignments or users that were not on the database the package was created from get removed.

Is there any way to stop this happening as we often have different database users and role assignments across our development, QA, UAT and production environments?
amaher
 
Posts: 2
Joined: Thu Aug 29, 2013 3:50 pm

Postby david.conlin » Mon Sep 02, 2013 10:45 am

Hi there -

If you are using SQL Source Control or SQL compare you can take their filter file and make Deployment Manager obey it using the technique below.

http://www.red-gate.com/messageboard/viewtopic.php?t=17776
[/url]
David Conlin
Software Developer
Deployment Manager
david.conlin
 
Posts: 50
Joined: Fri May 04, 2012 3:44 pm

Postby amaher » Mon Sep 02, 2013 1:05 pm

Thank you - That has done the trick.
amaher
 
Posts: 2
Joined: Thu Aug 29, 2013 3:50 pm


Return to Deployment Manager

Who is online

Users browsing this forum: No registered users and 0 guests