How to build a database that contain only the delta from yesterday
I need to know what has been changed on my database since last night. Is
it possible to extract this data from the LDF file and to build a new
Database that contains the delta?
For example, let say I have a table for users and now, a new user was
added and one of the users update his home address. I need to be able to
build a new database that users table will contain two records 1. The new
user (and to add a new column to know if it's new or update field) 2. The
user that update his record (it will be nice to know which record has been
update)?
BTW, I have to SQL servers that I can use (2008 and 2012)
Thanks In Advance.
No comments:
Post a Comment