ApexSQL Search is a free tool that can be used to search SQL Server databases for objects as well as creating charts that illustrates dependencies within the database. The tool can be found here.
The tool is an add-in for Visual Studio and Sql Server Management Studio. After installation, ApexSQL will show up in the menu for both applications. Mostly, I run it when in Visual Studio. Just open the Server Explorer window and create a database connection. Select the connection and choose one of the options from the APEXSQL menu. Select View Dependencies to open up a Dependency Viewer window that will show you a chart with every dependency in the database. This will be overwhelming, so you can toggle off different dependency types in the toolbar.
UPDATE 2/15/2019: The View Dependencies feature is no longer part of the free ApexSql tool. It looks like this is now part of their ApexSql Analyzer tool which is most definitely NOT free.
No comments:
Post a Comment