Skip to main content
Question

Projection constantly replicating?

  • August 3, 2020
  • 1 reply
  • 3 views

Joseph
Forum|alt.badge.img
  • Participating Frequently

We are doing some schema level replication using vbr

I have a projection that is constantly replicating .... ... The "owners" of the underlying table have assured me that this only gets updated on a batch basis - say once or twice a month - yet I see it replicating all the time (i am using a query with sal_storage_id to see this )...

I have searched QUERY_REQUESTS and cannot find inserts or updates or deletes other than that expected (as mentioned this is done once/twice a month in a batch) ......I therefore have no idea as to why this large projection is constantly replicating.......

Presumably vbr is "thinking" the object has changed and so needs to replicate......

1 reply

Sankarmn
Forum|alt.badge.img+1
  • Participating Frequently
  • August 3, 2020

@Joseph, in your case you should go with object level replication against schema level, where you can leave out the objects that are part of batch process.