Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Alternative to Dropping Replication Publication For Database Project Deployment? Expand / Collapse
Author
Message
Posted Wednesday, December 18, 2013 5:42 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 6:52 AM
Points: 179, Visits: 821
Hi All,

My scenario is this... We currently use database projects for our SQL development and then use Finalbuilder to deploy the project once a build is created (dacpac). This is then applied to the database but..we have replication for several articles in the database and this needs to be dropped beforehand and then created afterwards making this a bit of a manual process. I want to automate this for our Nightly builds but it seems that the script to drop and create has to be performed as a sysadmin and I don't want to give build accounts those elevated priveleges.

Has anyone had this experience and found a way around it?

All suggestions taken with thanks

Best Regards

E.


SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
Post #1524066
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse