Log Shipping - What has changed

  • nwood2009

    SSC Enthusiast

    Points: 115

    We currently have a situation with a vendor where they will only give us access to our data via 5 minute log ship files that we import into our read only db. this is fine for most queries, but we need a way to get details about what has changed in each period in the most efficient manner possible.

    Usually we would go to triggers and update another table, but we cant do that.

    Then we would try change data capture, cant do that either.

    What options are out there to get the changes?

    Can we read the log files themselves to parse out changes?

    Thanks for any help

    Nick

  • MVDBA (Mike Vessey)

    SSC-Insane

    Points: 21757

  • BrainDonor

    SSCoach

    Points: 19234

    A little left-field, but a snapshot backup just before the log file ships and then running a data compare (such as redgate's SQL Data Compare) between the snapshot and the original DB, after the log file has been processed, might give you what you need.

    Steve Hall
    Linkedin
    Blog Site

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

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