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
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).
https://learn.microsoft.com/en-us/sql/relational-databases/l...