0

I wanted to schedule the transaction replication. How do I do it? Currently I have set up a transaction replication which runs continuously and synchronizes the changes with immediate effect.

I need to configure a replication which will gather logs from the publication once in a day.

Is there any possibility?

abatishchev
  • 98,240
  • 88
  • 296
  • 433
vignesh
  • 1,414
  • 5
  • 19
  • 38
  • you can schedule replication jobs on subscriber for pull and publisher for push https://msdn.microsoft.com/en-us/library/ms151702%28v=sql.110%29.aspx – grillazz Jan 24 '15 at 16:26

1 Answers1

0

Check out CDC(Change Data Capture).

user3479453
  • 21
  • 3