After configuring replication all the data from tables has replicated from publisher to subscriber. Now my requirement is whenever I insert new record in publisher only that record should replicate rather than reinitialize all the records to subscriber because my table is having millions of records.

Rather than drop and reinitialize snapshot cont we store earlier sync data of table in subscriber and only sync the new record.

Is there any way to do this?

  • Unless this is a snapshot publication, this is how replication works. Which type of publication did you set up? Merge? Transactional? – spaghettidba Jun 11 '15 at 9:51
  • Transactional Rep – Gayathri L Jun 11 '15 at 10:08
  • My req is even though snapshot generated, Rather than drop and creation of article (table) cont we simple add the newly inserted row to already synced article in subscriber – Gayathri L Jun 11 '15 at 10:15
  • Sorry, but I don't understand what you mean. When the replication agent runs, newly added rows at the publisher are inserted at the subscribers. The snapshot is used only to initialize the subscription. What am I missing? – spaghettidba Jun 11 '15 at 10:19
  • It will insert entire table whenever snapshot has generated, I will first time insertion next onwards only inserted rows – Gayathri L Jun 11 '15 at 11:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.