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