跟踪Microsoft SQL Server数据库中的更改 [英] Track changes in Microsoft SQL Server database

问题描述

我想知道MS SQL Server中是否有任何功能可以让我有机会跟踪表之间的数据移动?

I would like to know if there are any features in MS SQL Server that will give me the opportunity to track movement of data between tables?

我正在为一个数据库驱动的应用程序提供客户支持，该应用程序在一个数据库中有数百个表.在应用程序中注册的数据经历了一系列阶段，当在这些阶段之间进行转换时，数据通常会从一个表移动到另一个表.

I am doing customer support on a database-driven application with hundreds of tables in one database. Data registered in the application goes through a series of stages, and when transitioning between these stages the data often moves from one table to another table.

我想更好地了解应用程序的基础数据模型，因此，如果有任何机制或其他方法来跟踪数据库中的插入，更新，删除或其他移动，这将是有帮助的.

I would like to get a better understanding of the underlying data model of the application, and therefore it would be helpful if there is any mechanism or other method to track inserts, updates, deletions or other movement in the database.

例如，如果我在应用程序中注册数据，那么我希望以后再去SQL Server Management Studio，并得到某种通知，即将新数据插入到表X中.如果我对数据进行更改在应用程序中，我可以返回到SQL Server Management Studio，查看数据已从表X删除并添加到表Y.

For example, if I register data in the application, then I would like to go to preferrably SQL Server Management Studio afterwards and get some kind of notification that new data has been inserted into table X. If I do changes to the data in the application I can go back to SQL Server Management Studio and see that data has been deleted from table X and added to table Y..

推荐答案

您可以阅读以下内容:

• SQL Server审核，

更改数据捕获

您也可以通过触发器捕获它，但是在数据库级别上并不好.

You can also capture this by triggers, but it's not good at database level.

这篇关于跟踪Microsoft SQL Server数据库中的更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！