ApexSQL Clean

This tool can recognize SQL Server database dependencies and help remove unwanted objects without risking any problems.

ApexSQL Clean helps analyze SQL Server database objects. You would be able to pinpoint dependencies within the database, across databases, scripts and even applications. This tool will recognizes all such database dependencies. Some dependencies are not even recognized by SQL Server, often. When all such dependencies are known related to an object, you know exactly what the implications are when such an object is removed. This tool will thus help clean up the database by analyzing dependencies related to the unwanted objects. This analysis helps map dependencies down to the table column level. It will help specify database processing criteria, check or ignore the relationships for an objects, etc. You are able to clearly see the impact of removing a particular object. SQL object relationships could be visualized easily.

This has a simple and easy to use interface. It is intuitive enough that most users should get familiar with it quite easily. Getting productive with it should not take much time. This tool is not for just any user. Database users who need help in such sophisticated areas will easily be able to operate the tool. The interface display arrangements make very good sense to such users. They will easily be able to pinpoint the dependencies they are looking for. A command line interface is available. Extensive reporting is available. This is a very good product. If you are looking for a similar solution, you should try it in your exact workflow.

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 2012 support (all other SQL Server versions are also supported - 2008 R2, 2008, 2005 and 2000), so you can analyze SQL Server 2012 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.