Introduction to Change Tracking Framework

Introduction to Change Tracking Framework

The change tracking framework provides features that track DML changes (insert, update, and delete operations) in a database.

You can:

  • Create and drop change tracking triggers.
  • Create and drop procedures to select changes.
  • Restore changed records.

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:

  • Database tables, views, and procedures to store and manage changes;
  • Configuration objects to manage change tracking in Microsoft Excel for administrators;
  • Configuration objects to track and restore changes in Microsoft Excel for end users.

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)

https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/track-data-changes-sql-server?view=sql-server-2017

We have created the change tracking framework for SQL Server to get the following features:

  1. To see historical data in Microsoft SQL Express (not supported by the Change Data Capture feature).
  2. To easily integrate and use the solution in Microsoft Excel (not supported by SQL Server).
  3. To allow business users to manage change tracking features and rollback changes using Microsoft Excel.

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