| tootsuite@gmail.com 2006-10-24, 6:38 pm |
| Hi,
I have a question about replication in SQL Server 2005, transactional
replication. I have an already existing publication, and I had to add
another table (article) to the publication. Obviously, this newly added
table on the publisher and subscriber will not automatically be in sync
unless I do something to make them in sync.
I have a tool that I use to sync the tables up so that I don't have to
apply a snapshot. However, I am wondering, is it possible to apply a
snapshot to a single table in a publication without applying the
snapshot to any other tables? I have turned off the snapshot agent job,
also, since we never use snapshots.
What are the ramifcations of applying a snapshot? Does it drop and
recreate the table? I spoke with a Microsoft tech person a while back,
and even he did not really explain to me what *really* happens when you
apply a snapshot... so, still wondering. He says it "synchronizes" the
tables but that really does not explain anything.
Thanks
|