The change tracking framework provides features that track DML changes (insert, update, and delete operations) in a database.
You can:
You can execute the operations in SSMS, your application, or in Microsoft Excel using the SaveToDB add-in.
Moreover, you can easily extend Excel context menu to track changes in Excel.
The framework includes the following blocks:
You can download and install the framework in a couple of minutes.
The framework uses features of the SaveToDB Express add-in for Microsoft Excel. So, you can use it for free.
Microsoft SQL Server includes built-in features to track changes. You can read the following article, for example:
Track Data Changes (SQL Server)
We have created the change tracking framework for SQL Server to get the following features:
We get a reliable and high-performance solution that you can use for free.
Try the framework. You can save a lot of time and make your users happier.
Best regards,
Sergey Vaselenko
November 8, 2017