SQL - How to revers engineering to discover the source of the data

tommym121 used Ask the Experts™
I am working on a data migration project.   I have been successfully migrated most of the information from a database (SQL server 2008) by using a front-side database client application.  However there is few fields on the front-side database client application that I am not sure the corresponding columns of a table.
Is there any way to discover which columns or tables that are touched when I try to update a record from the front-end database client application
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
The Sql Service Profiler (under Sql Service 2008 - Performance Tools ) gives you options to trace activity.

It is very helpful if you specify filters to prevent getting volumes of trace logs.



Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial