Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
Posted Wednesday, December 18, 2013 5:42 AM



Group: General Forum Members
Last Login: Tuesday, October 25, 2016 2:13 AM
Points: 193, Visits: 974
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


Every day is a school day, and don't trust anyone who tells you any different.
Post #1524066
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse