Bravo team update: ApexSQL Clean, ApexSQL Doc, and ApexSQL Trigger

What have you been working on?

We have released ApexSQL Clean 2014 R4 maintenance version

We have released ApexSQL Doc 2015 R4 maintenance version

We have released ApexSQL Trigger 2015 R1 major version

We are currently working on ApexSQL Doc 2015 R5 version – a documenting tool for SQL Server instances, databases, objects and SQL Server Integration Services packages. It generates comprehensive documentation in a number of formats including CHM, HTML, Microsoft Word’s DOC and DOCX, and PDF

What is the ETA to production?

ApexSQL Clean 2014 R4 is released. See the latest release notes here

ApexSQL Doc 2015 R4 is released. See the latest release notes here

ApexSQL Trigger 2015 R1 is released. See the latest release notes here

ApexSQL Doc 2015 R5 is planned for release in October 2015. See the What’s next page here

What is included in new releases?

For ApexSQL Clean 2014 R4 we have been working on bug fixes and improving quality

For ApexSQL Doc 2015 R4 we have been working on bug fixes and improving quality

For ApexSQL Trigger 2015 R1 we introduced a new feature – possibility to audit DDL changes. Users are now able to track DDL changes on audited database, collect data and generate reports in the similar manner they are tracking DML changes


Figure 1. Report with audited DDL changes

How to configure and use DDL auditing in ApexSQL Trigger is explained here.

We also fixed 37 bugs for this release

What is planned in future releases and what are ETAs?

ApexSQL Doc 2015 R5 – ETA is October 2015:

  • Display interactive graphical dependencies objects – objects from the graphical dependencies are now links to the selected object page in the generated document
  • Granular documentation of object level attributes – fully customize documentation by selecting which attributes to document on object level


    Figure 2. Select which attributes to document on object level

  • SQL Server 2016 CTP2 support
  • SQL Server Management Studio 2016 CTP2 integration

This release will also include more than 30 fixed bugs

For the complete list of features coming in the future releases of ApexSQL Doc, please visit Roadmap page here

ApexSQL Clean 2014 R5 – ETA is the end of Q4 2015:

  • Full support for Azure SQL Database V12
  • Support for SQL Server 2016 CTP2

ApexSQL Trigger 2015 R2 – ETA is the end of Q4 2015:

  • Full support for Azure SQL Database V12
  • Support for SQL Server 2016 CTP2

ApexSQL Doc 2015 R6 – ETA is the end of Q4 2015:

  • Data model / UML diagrams
  • The ability to document only server information
  • Document SSIS packages from SSISDB catalog
  • SSIS package details
    • Project parameters
    • Log entry information
    • Extended properties
    • Configuration settings
  • SSIS Source and destination mapping
  • Insert page breaks for better readability
  • Apply setting in the Custom text tab for both header and footer
  • Insert indentation in DOC, DOCX and PDF formats
  • Include database objects in DOC, DOCX and PDF formats
  • Group objects by database level (like in SQL Server Management Studio) in CHM and HTML formats
  • Document specific database object from SQL Server Management Studio
  • Support for all Azure SQL Database V12 features

ApexSQL Doc 2016 – ETA is the end of Q1 2016:

  • Annotate database objects locally
  • Dependencies between SSIS packages and referenced database objects
  • SSAS Cube documentation
  • SSRS Report documentation
  • Insert on-page navigation – current path
  • Insert bookmarks in PDF
  • Stylize object description with HTML tags
  • SQL Server 2016 support
  • Documentation preview

See the What’s next page here for details on all future releases

If you have any issues or suggestions on your mind, feel free to contact our support and send us your feedback. That will help us to make better tools for you

September 24, 2015