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.