Post reply

Replicating only Newly added Article in SQL Server 2008 R2

  • August 19, 2013 at 6:31 am

    #278794

    I am using an publisher as Oracle database and my Distributer and subscriber are both SQL server.i added an article on the SQL server and when i started the snapshot job it replicated all the existing articles.I have heard of Immediate_sync and Allow_anonymous would be useful in order to run an snapshot for only the new Article but the problem is my publisher is oracle so how can i set these values on my oracle Publisher.kindly help me out.

  • August 25, 2013 at 2:08 am

    #1644706

    Please help me anyone i am struck currently i am facing another issue..when i am replicating an article using snapshot agent its giving me unique constraint error and its giving message "skipping the article as it has be replicated in earlier snapshots" but i want to replicate it again which i am not able to do because of an constraint..please help me out i am struck very badly.

Viewing 2 posts - 1 through 1 (of 1 total)

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