Hello,

Sorry if this is a little convoluted, but I have an active customers table that gets updated daily (updates, deletes, and inserts) with about 1.5 million rows. What I would like to do with this table is to run reports of the table in different snapshots in time. Let's say I want to run the August report on the table based what the table looked like on August 31st or retroactively run January report on January 31st data. Is this possible without making a complete backup of the table at the end of every month?

In my mind, I'm thinking, how do I create and keep a small snapshot of the data every month and have the snapshot only keep track of incremental changes? Does anyone have a good solution to this?

Thanks!