Post reply

replication

  • March 9, 2017 at 7:14 am

    #328185

    I have  transactional replication configured on my environment .  update , insert and delete are doing in publisher . I need to replicate only the update and inserts to the subscriber . How can we do ?

  • March 9, 2017 at 10:18 pm

    This was removed by the editor as SPAM

  • March 10, 2017 at 12:55 am

    #1932654

    Hi,
    I think  this is not possible. A delete is a transaction, and every transaction is replicated.
    If you would work with log shipping, same procedure, every transaction is  "logshipped".
    Best regards,
    Andreas

  • March 10, 2017 at 2:04 am

    #1932658

    ramyours2003 - Thursday, March 9, 2017 7:14 AM

    I have  transactional replication configured on my environment .  update , insert and delete are doing in publisher . I need to replicate only the update and inserts to the subscriber . How can we do ?

    Have a look at sp_changearticle.
    I've never altered an article myself - I usually drop and recreate it if it needs such work doing. However, it looks like sp_changearticle with
    @upd_cmd = N'NONE' 
    should do as required.
    As ever, test this somewhere safe first.

    Steve Hall
    Linkedin
    Blog Site

  • March 10, 2017 at 3:02 am

    #1932664

    Thanks for the replies ..

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply