Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replicating only Newly added Article in SQL Server 2008 R2 Expand / Collapse
Author
Message
Posted Monday, August 19, 2013 6:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 24, 2014 9:09 AM
Points: 6, Visits: 71

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.

Post #1485761
Posted Sunday, August 25, 2013 2:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 24, 2014 9:09 AM
Points: 6, Visits: 71
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.
Post #1488193
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse