Hi all
We have a 3rd-party software vendor who puts data into some SQL tables.
We want to replicate the databases across to various other servers but have a potential issue.
The vendor has said that replication will need to be switched off for certain tables while they make various changes (please, don't ask!!).
My question is this, if we switch of replication for tables x,y and z (out of the full alphabet) and let the rest continue replicating, will we need to completely reinitialise the entire replication or can we just switch on replication for tables x,y and z?
If we can just start replication for those few tables (using the same publisher/distributor settings so everything is in one place), how would we do that?
I'm not sure how to start replication for just a few tables if replication for others is already running.
Any advice/help on this would be greatly appreciated.
Create two publications - one publication would be tables x,y,z, the ones you need to turn off. The other publication would be tables a - w, the ones you can leave on. You can just stop and start the replication agents for the publication.
I would guess based on what the vendor is saying that you would need to reinitialize the publication with x,y,z. And then again, he may not know why replication needs to be turned off and is just saying that for whatever reason. You'd want to find out what those changes are that they are doing. In any case, if reinitializing is workable based on the size of the publication, then just reinitialize the x,y,z publication and start the agents.
Sue