Tracking changes in data over time is a common problem, and deciding on your approach relies on answering questions such as “Do I want to track every field or just some fields?”, “Does it need to be ‘live’ or is it okay to detect changes within a period of time?” and “What audit fields are available to me and what degree of tracking is needed (e.g. deletions vs. just updates)?”
source https://www.c-sharpcorner.com/article/auditing-data-changes-in-microsoft-sql-server/
No comments:
Post a Comment