Using msrepl_tran_version as method to select records for an upsert operation

  • 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

     

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

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply