I think your idea can work well to identify inserts and deletes, regardless of how large the tables are.

The key condition is that you have a stable business key (not...

Hi Bogdan, that can certainly work in some scenarios.

One important difference, though, is that restoring from a snapshot affects both data and metadata. If you restore a snapshot from, say,...

Hi Bogdan, thanks for your comment.

I totally agree with you — sometimes we tend to introduce unnecessary complexity where a simpler approach would do the job.

That said, part of the...

Thanks for your comment, Phil. You know, sometimes we assume that what happens to us, happen to the whole world. Perhaps I should have said, 'It often happens to me'