Hello community,
I am looking for a tool which allows me to reverse engineer an existing (windows) legacy business app by tracking the changes made on the SQL database if certain actions are executed within the legacy system. So basically my workflow would be:<p>1. Launch reverse engineering tool and connect it to the (Microsoft SQL Server) database
2. Reverse engineering tool captures a snapshot of the database
3. Reverse engineering tool listens for database changes...
4. Launch legacy business app and execute some business process manually
5. Check changes in database in reverse engineering tool (new, modified and deleted data). Ideally visualize the changes to the user<p>Centuries ago, there was a tool called FileAid from CompuWare which allowed me to do exactly what I am looking for, but it seems that this tool changed completely and just the name is still the same (after the company was sold many times).
thats a journal or transaction log: all you need is a tool to view it<p><a href="https://learn.microsoft.com/en-us/sql/relational-databases/logs/the-transaction-log-sql-server?view=sql-server-ver16" rel="nofollow">https://learn.microsoft.com/en-us/sql/relational-databases/l...</a>