3

I am re-writing the question below to provide more details.

We have a legacy application and are now developing it using a new technology. The database is SQL Server 2014. We know 90% of the tables that get updated when an operation is performed on the UI. However, we are not sure if we have covered all the tables.

The customer wants us to run a scan of the database on the old system when an operation is performed on the front end and then do the same with the new application. HE would like to make sure that we are touching the same tables in the old and new application.

So, I would like to understand if there is some query I can run that will give the list of tables that were updated when I perform an operation on the front end. All the tables have last update date and user who performed the update.

  • Why do you use the old application's schema for the new application? Create your own schema to match the application functional requirements, and you will not need to reverse-engineer the legacy application. – mustaccio May 14 '15 at 16:35
  • What exactly do you have as part of the old application? – Konrad Gajewski May 14 '15 at 18:45
4

You can setup a test database and trace the application activity using the SQL Server profiler. By tracing the event "Security Audit\Audit Schema Object Access Event" you can effectively trace all the SQL the client is sending to the server. But that will not necessarily help you in discover the application logic.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.