ApexSQL Doc

Handling large databases can get confusing at some point, especially for someone who is seeing one at a first glance. It is considered good practice to create documentation for any database that you create, so that anyone using it will have a clear view on how tables, queries and SQL entries are all connected.

ApexSQL Doc is a handy tool that can help you achieve all this. The application gives you the possibility to create HTML or CHM documentation for each of your databases or for each particular piece of information they contain. In order to properly work, the program requires, Visual Studio SDK, Microsoft Help Compiler, Microsoft ActiveX Data Access Objects Library, .NET Framework and Microsoft SQL Server installed and running on your computer.

The application allows you to generate database and SSIS documentation, then save it to a CHM, HTML and Word-compatible format. This way, you can attach a documentation to a database in order to help anyone using it better understand the connections behind each table or view.

You can select which information gets included in your generated documentation, thus helping you automate the process of creating CHM, HTML and Word help files.

With the help of ApexSQL Doc, you can create database documentation that contains certain objects that are generated within your queries, such as relationship diagrams.

You can easily edit the properties of your databases directly, so that your final documentation contains correct information.

To sum it up, ApexSQL Doc provides you with a stable environment for creating documentation for your databases, based on the information they contain. You can also edit the information before using it to build your documentation, thus ensuring data consistency and correctitude.