ApexSQL Clean Identifies Unused and Unreferenced Objects in Databases

Drops Generation Wizard

This wizard lets you create a script to drop unreferenced objects. A nice feature of this product is that it can create a backup of the database before you execute the drops script.

The output options let you define the type of output needed. You can save the script to .sql format, opening it with the internal editor, writing it to a file only, or executing it directly against the database.

Viewing the script in the internal editor:

Help

Help is bundled with the application and you can update the product online once you have entered a valid activation key.


Conclusion

There are many reasons why orphaned objects can appear in a database during the development stage; for example, one developer might forget to document an object. Keeping orphaned objects out of the production database makes it easier to maintain.

It is a long, tedious job to find unreferenced objects in a big database. Thanks to ApexSQL Clean, we have a very good tool that can help us do this.

Pages: 1 2 3 4 5




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |