Forum Discussion
sql server 2019 how to reverse engineer a View using VS or Visio
Hi, I am trying to trace back, and document the lineage of a series of Views that have been created in SQL Server 2019 over many years. Many of the views are quite complex and are Views built o...
Hi Dosania
I know this is an old thread, but if you are still looking for a solution, I had the exact same problem analyzing views and stored procedures.
I built an open-source VS Code extension to solve this. It runs completely offline against a .dacpac or standard DMVs, addressing your security and third-party concerns. It maps the dependencies visually and lets you export the graphs to Draw.io for your engineers.
You can find it on the VS Code Marketplace under Data Lineage Viz.
Greetings,
Christian