Scenario:
We have a PHP/MySQL based corporate web portal and a separate MS SQL database on a remote server which could be accesed by a 3rd party vendor Java application(web client communicating with the MSSQL database).
Requirement:
I would like to get rid of that Java application and transfer all functionalities to the PHP web portal and I need to figure out the queries as I don't have the source code of that Java application and there is no way to reach the vendor to ask.
Is there any way I can capture the queries that Java application is sending so I can use those in my PHP scripts?
Maybe tracing last queries from MSSQL somehow? Or
Somehow see what the Java application emits to the database in some way?