Replicated SQL Database - Advice on how to do
Hi,
We use TeamCity (10.0.5) to deploy our Visual Studio database projects to our SQL Servers and it all works fine, with one exception, one of our database is a SQL 2012 replicated database, when the deployment which is made up two steps (build and deploy), the build works fine but the deploy step fails with the following error;
Atrium DB Apps :: UserDB :: 2. UAT > #22 (18 Oct 16 12:53) > Build Log — TeamCity
EXEC error SQL72035: [dbo].[Users] is replicated and cannot be modified.
I wondered how other users of TeamCity dealt with SQL Server replicated objects, do I need to remove the replication, do the build and then re-initial the subscriber (what a pain that would be) or is there another solution.
Any and all thoughts would be greatly appreciated.
Thanks,
Nic
Please sign in to leave a comment.
Hi Nic,
What kind of step are you using? At which point is it failing? I can't say what the issue is right now, but knowing more of the context might bring some light to the core of the problem.