January 18, 2017 at 9:22 pm
I have a transaction replication and the subscription was synced from snapshot years ago. Now I have a new table that needs to be added to the replication. Problem is the table is close to a TB and I do not want to generate a snapshot for that table instead just want the new data to be synced, kinda like when you sync from backup. Its inserts only to the table and I can sync the old data manually later.
How do I make replication to start transferring the data without generating the snapshot.
January 18, 2017 at 11:29 pm
Hi,
I think this is impossible, if you try to add new article to your subscription, and you play with these 2 parameters:
EXEC sp_changepublication
@publication = 'your_publication_name',
@property = 'allow_anonymous',
@value = 'false'
GO
EXEC sp_changepublication
@publication = 'your_publication_name',
@property = 'immediate_sync',
@value = 'false'
GO
you only create a snapshot for the new article. In your case, if the table ist x TB big, you create a snapshot with x TB.
Kind regards,
Andreas
January 24, 2017 at 8:13 am
jesijesijesi - Wednesday, January 18, 2017 9:22 PMI have a transaction replication and the subscription was synced from snapshot years ago. Now I have a new table that needs to be added to the replication. Problem is the table is close to a TB and I do not want to generate a snapshot for that table instead just want the new data to be synced, kinda like when you sync from backup. Its inserts only to the table and I can sync the old data manually later.
How do I make replication to start transferring the data without generating the snapshot.
add article to publication with sp_addarticle and after this run sp_addsubscription with @sync_type = 'replication support only"
check @sync_type parameter.
https://msdn.microsoft.com/en-us/library/ms181702.aspx
BartL
Replication Blog
January 25, 2017 at 2:01 am
Hi,
if you just want to replicate the newer data, you can create and work with this kind of "filter":
https://msdn.microsoft.com/en-us/library/ms151775.aspx
If you have synchronized your data, you can tune your filter, to get more and more data from the publisher to the subscriber.
Kind regards,
Andreas
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply