Using msrepl_tran_version as method to select records for an upsert operation

• latkinson

  SSCommitted

  Points: 1587

  More actions

  May 14, 2020 at 12:33 pm

  #3751482

  I have a situation where I am pulling data into my DW from a server that is populated by replication from the production OLTP server. I am curious as to whether the value of msrepl_tran_version can be used reliably as an indicator that a record has changed. I have some instances where I would like to use it to control the records going into an upsert rather than a wipe and reload operation.

   

  Thanks

  Luther

   

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  May 15, 2020 at 1:10 pm

  #3751993

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.