Publisher is Oracle Database (configured in SQL 2012)
Subscriber is SQL 2014
Replication Type: Snapshot
Issues:
I need to add and initialized new articles only from an existing publication. However, instead of initializing only those newly added articles. All articles within the publication were initialized.
I've tried this but to no avail (as based on what I read. It is only applicable on Transactional replication)
EXEC sp_changepublication
@publication = 'Pub_Name',
@property = 'allow_anonymous' ,
@value = 'false'
,@publisher = 'COMP101' -- to be added if Publisher is Oracle
GO
EXEC sp_changepublication
@publication = 'Pub_Name',
@property = 'immediate_sync' ,
@value = 'false'
,@publisher = 'COMP101' -- -- to be added if Publisher is Oracle
I've also tried to refresh the subscription after adding new articles. But same issue arise.
EXEC sp_refreshsubscriptions @publication = 'Pub_Name', @publisher = N'COMP101'