Page 1 of 1

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

Posted: Sun 17 Jul 2022 23:40
by 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

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

Posted: Mon 18 Jul 2022 15:49
by shaw22
Good Morning

Please comment

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

Posted: Wed 20 Jul 2022 12:08
by 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