问题
Michael Lei · 四月 21

来自英文社区的问题:跟踪DAT /数据库随时间的变化,类似于SQL ChangeLog

你好,

我们需要跟踪数据库随时间的变化-如果可能的话,跟踪到SQL粒度级别。例如:用户xyz运行例程^ abc,我们得到类似于更改日志的信息,该日志告诉我们:表A的值已更新,插入,更新等。

是否可以使用IRIS级别的工具(审计日志,Journal文件等),将日志的全局集和终止数转换为SQL级别更改?

我还找到了一个名为Liquibase的第三方基于Java的工具,但它似乎更适合于跟踪基于架构和表的更改或预定义的定义。

谢谢,

詹姆士

Tracking DAT / Database Changes Over Time, Similar to SQL ChangeLog

Hello,

We have a need to track Database changes over time - down to the SQL level of granularity if possible. Such as: User xyz runs routine ^abc and we get something similar to a changelog that tells us: table A had this value updated, insert, update etc....

Is that possible using IRIS level tools (Audit Log, Journal File, etc...) , is there a way to convert the global sets and kills from the journals into SQL level changes?

I also found a third-party java-based tool named Liquibase , but it seems more oriented to tracking schema and table based changes or pre-defined definitions.

00
1 0 0 20
Log in or sign up to continue