C# & SQL Server realtime DML events

Asked May 27 '20 at 14:15

Active May 27 '20 at 15:21

Viewed 158 times

I have a requirement to generate DML events (insert, update, delete) from SQL Server to an external entity. I have tried implementing extended events using the Microsoft.SqlServer.XEvent.XELite nuget package. But it does not provide the row data, but only the statement executed.

I have also seen the fn_dblog function to retrieve the data from transaction logs. But it seems too complicated.

Is there any other way to achieve this (without of course using triggers or any manual work like CDC)?

edited May 27 '20 at 15:21

marc_s

732,580
175
1,330
1,459

asked May 27 '20 at 14:15

Babu James

2,740
4
33
50

3

Change Data Capture. https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-data-capture-sql-server?view=sql-server-ver15 – David Browne - Microsoft May 27 '20 at 14:38
@DavidBrowne-Microsoft, thank you for reply. Without using CDC (updated question)? – Babu James May 27 '20 at 14:39
If you don't want to write code there are 3rd party products, like Striim, Qlik, GoldenGate, or Debezium. – David Browne - Microsoft May 27 '20 at 14:46

C# & SQL Server realtime DML events

0 Answers0