Looking for an SQL Log Reader that will show the transaction and the tables affected from a specific time forward

[shaw22]

Hello,
I am trying to document what happens to the backend tables when an action is performed through the application menu interface.

Will the devart transaction log for SQL server will show me all the INSERTS, UPDATE, DELETE, SELECT and MERGE and the tables and data involved?

The plan I have is to copy the production database to a play database and then connect to play database with the application front end and do transactions and then look at the transaction log using devart transaction log and document what happens when a certain action is peformed through the front end interface of the application

Thanks

[shaw22]

Good Morning

Please comment

[dzhanhira]

Hi,

We would highly recommend testing it within your environment.
Please check this article:
https://blog.devart.com/view-the-sql-se ... -tool.html

Our dbForge Event Profiler for SQL Server night be useful in this case as well:
https://www.devart.com/dbforge/sql/event-profiler/

So, please download both tools and give them a try.
And during the trial you may get assistance while performing particular steps from our support team:
[email protected]

1. Free trial of dbForge Transaction Log:
https://www.devart.com/dbforge/sql/tran ... nload.html

2. Free trial of dbForge Event Profiler:
https://www.devart.com/dbforge/sql/even ... nload.html