ApexSQL Clean

ApexSQL Clean analyzes SQL Server database objects, dependencies within the database, across databases, scripts and even applications. It recognizes all database dependencies, even those not recognized by SQL Server itself. ApexSQL Clean helps you remove unwanted objects risk free, map dependencies down to the table column level, specify database processing criteria, check or ignore the relationships for specific objects. You can also schedule unattended SQL dependency checking using the command line interface and create end-user reports to document the interdependencies in your environments. ApexSQL Clean comes with SQL Server 2016 support (all other SQL Server versions are also supported – 2014, 2012, 2008, 2005), so you can analyze SQL Server 2016 object relationships and identify FileTable, sequence, search property list, column, store index, poison message, handling attribute for queues, as well as geometry and geography auto grid tessellation scheme for spatial indexes dependencies.

Features:

• View and analyze SQL and client code dependencies
• Create and execute drop script
• Analyze external databases for dependencies
• Perform impact analysis on potential changes
• View object dependencies graphically
• Create and export reports from object dependencies