I have access to an MS SQL Server DB and I'm able to run queries on the databases.
But the since the database is too big, with multiple tables and each table having many columns (whose names aren't descriptive), I don't know which data is where.
I assumed I could use nc
or Wireshark
to listen to the port and learn from the backend about data in the DB (I have access to the frontend and the DB). But SQL server data traffic is encrypted. So I downloaded Microsoft Tools like Microsoft SQL server manager
and Microsoft Message Analyzer
and starting out.
Question
Are there ways to figure out "which data is where" in a DB?
What must be my approach to understand the database?