Are you tired of manually documenting your SQL Server databases and SSIS packages? Look no further! In this article, we will explore ApexSQL Doc, a powerful SQL documentation tool that can save you time and effort.

ApexSQL Doc is a SQL Server database development tool that generates documentation in various output formats such as chm, html, doc, and docx. It allows you to include relationship diagrams in the documenting process and customize the preview settings.

One of the key features of ApexSQL Doc is its ability to show extended properties for all database objects created at the SQL Server level. With the Extended property editor feature, you can easily manipulate previously created descriptions or add new ones.

Getting started with ApexSQL Doc is easy. Simply download and install the tool, and you’re ready to go. The new version of ApexSQL Doc 2014 even supports SQL Server 2014 and Integration Services 2014, with a new UI style.

To begin documenting your SQL Server databases, you can start a new project in ApexSQL Doc. You can add multiple SQL Server instances and choose the databases you want to include in the documentation process.

ApexSQL Doc allows you to document both server objects and database objects. For server objects, you can select a combination of objects and generate a bitwise set number that represents that specific combination. This number can be used in the Command Line Interface (CLI) for automation purposes.

When it comes to database objects, ApexSQL Doc provides a user-friendly interface to select the objects you want to document. You can also use the Filter editor feature to apply advanced filtering conditions to the objects.

Another great feature of ApexSQL Doc is its ability to include graphical dependencies in the documentation. You can customize the dependency type and layout settings to improve the visibility of the dependencies in the output document.

ApexSQL Doc also offers a variety of output styles to choose from. You can select one of the predefined styles or manually edit them to suit your needs. A full preview of the output styles is available in the Preview section.

Before generating the documentation, you can review and edit database extended properties using the Extended property editor. This allows you to add or modify object descriptions at the SQL Server level.

Once you have everything set, you can generate the documentation with a click of a button. ApexSQL Doc supports various output formats such as chm, html, doc, and docx. You can even save the documentation file as a PDF using MS Word.

ApexSQL Doc also provides options for documenting SSIS packages. You can document online from SQL Server or Integration Services, or offline from the file system. The process is similar to documenting databases, with the ability to select the objects you want to include in the documentation.

Automation is another powerful feature of ApexSQL Doc. You can use the Command Line Interface (CLI) to automate the documentation process and schedule it using SQL Server Job or Windows Task Scheduler.

With ApexSQL Doc, documenting your SQL Server databases and SSIS packages has never been easier. Say goodbye to manual documentation and start saving time and effort today!

Download ApexSQL Doc now and experience the power of automated SQL Server documentation.