Forum Discussion
create backup from a table if Data changes
hello to All,
please, i'm new in SQL , and need help if you can
i have a database in SQL, i would like to create auto backup for a Customer table everytime when data changes in that table to keep the historical changes
for exemple; if the Seller or the Situation of a Customer changes , i would like to create a new row with the new information of the costumer
thank you
2 Replies
- The provided informations are very less.
One way is CDC = Change Data Capture:
https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/enable-and-disable-change-data-capture-sql-server?view=sql-server-ver16 This is maybe a solution?
https://learn.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables?view=sql-server-ver16
