June 4, 2015 at 10:52 am
Hey Everyone
Just a quick question,I currently have SQL Server Transactional replication running. Server A (Publisher & Distributor) to Server B (Subscriber).Everything is working great. I just need to know whether i can add a table to the subscriber only in that database? will it affect my replication? must the databases be the exact same in terms of schema etc?
I need to add a table thats not part of the published articles on Server B(Subscriber).
Thanks
June 4, 2015 at 11:02 am
This is not an uncommon scenario, and you can this with no issues.
Where you run into issues is when you modify the replicated objects in the subscriber database.
A good example is when we had this well meaning junior DBA add all of the possible foreign key constraints to the subscriber database. Replication started breaking.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 4, 2015 at 11:04 am
Thanks Michael for the quick response.i will give it a go. 🙂
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply