2011-07-06 16:56:28 UTC
which I would like to add articles from time to time withouth having
to re-apply the complete refreshed snapshot to the subscriber. (just
creating the snapshot has adverse effects on our oltp).
I was wondering which of these objects can be added without having to
completeley re-initialize the subscriber database from the snapshot?
Adding a Table Article
Adding / removing Indexes
Changes to Article Table columns
I was hoping that adding an article to a publication and then adding
the article to the subscription would result in some kind of DELTA
processing that would simply add that table and data to the subscriber
(withouth the full re-build of the Subscriber database as happens when
you use the wizards).
But then again I don't understand the underlying stuff as well as I'd
I can understand that if I make a change to an Article such as
including all indexes or changing the column list that this might not
be implementable as a delta. I can see FKs being a lot of fun too
which is probably why I didn't include them.
Not thrilled about reading books on-line about thsi stuff as the
information is not clear and concise. Any other effective sources to
Maybe its not a good idea to bring Indexes along as part fo teh
replication but to apply those separately to the Subscriber?
Thanks for your help