Cheat Code
ApexSQL Analyze
I’m working with amazing data warehouse project where all ETL is done in Stored Procedure and being documented in WORD document! It’s just 7MB and 194 pages, good reading material for couple of hours flight, hope I don’t fall a sleep…
My objective here is to get the dependency between tables (oh, not much constraints being done on this DB – isn’t that amazing!?). And understand the logic a.k.a data lineage. Too much mystery here.
So I deployed the schema to Azure SQL just for my playground.
Spent couple of hours googling the internet and came across this tool ApexSQL Analyze, reading the features seems exactly what I need. So I downloaded the tools and start the trial.
I started the tool and here is the landing screen, super clean!
What a pleasant surprise that it supported Azure SQL with Active Directory. YAY! no need to create dummy SQL Login account š
After waiting for awhile, it generate a fancy map.
After playing for couple of moment I just feel this is not exactly what I want.
While it kind if nice to show visually which object depends on which one others, but it stop at it. It doesn’t go into deeper stored procedure and perform at column level.
Summary
It’s a neat and easy to use tool to show visually object dependencies but I think it stop there.
My IT Cheat Code 