BI Documenter - Microsoft
"I'd say you have a very impressive and extremely useful product here. I highly recommend [BI Documenter] to anyone who wants to take snapshots of their SQL Server BI solution... Cool product."
Kirk Haselden

Development Manager

SQL Server Integration Services, Microsoft Corporation

BI Documenter - John Dempsey
"BI Documenter allowed me to document not only the database objects, but SSIS, SSRS, and SSAS too. This is a great benefit. It provided access to their metadata database repository the software used which I felt was a big plus. A must have tool."
John Dempsey
BI Documenter - VCU Health System
"The time and effort BI Documenter saves my team by documenting the entire BI stack is priceless."
Carlos Dickens

Manager, Data Warehouse

VCU Health System



Buy Now Free Trial Download Free Live Demo!                        
SQL Server Database Documentation

BI Documenter provides you with the information necessary to better understand each of your SQL Server Databases. Whether it is using parent and child dependencies to update Database Schemas or utilize an entire DDL Script provided by BI Documenter to recreate a lost or damaged environment, BI Documenter SQL Server Database documentation is here to help.

Feature Highlights:

  • Easily recreate SQL Server Database objects using the full DDL Script that is captured and displayed by BI Documenter
  • Use parent and child dependencies to quickly understand the complexity of your SQL Objects to help you make educated decisions when planning changes
  • Display recommendations and alerts for potential performance related issues
  • Build a better picture of each table by viewing sample data and statistical information such as %NULL, Min Value, Max Value, and %Unique
SQL Server Database Documentation

SQL Server Database Documentation step 1

All Major SQL Server Databases Documented!

  • BI Documenter allows users the ability to document databases across all major versions of SQL Server: 2005, 2008, 2008 R2, and 2012.

All Major SQL Server Databases Documented!

  • BI Documenter allows users the ability to document databases across all major versions of SQL Server: 2005, 2008, 2008 R2, and 2012.

SQL Server Database Documentation step 2

Full DDL Scripts Provided

  • Easily recreate SQL Server Database objects using the full DDL Script that is captured and displayed by BI Documenter.

Full DDL Scripts Provided

  • Easily recreate SQL Server Database objects using the full DDL Script that is captured and displayed by BI Documenter.

SQL Server Database Documentation step 3

Object Dependencies Included

  • Both parent and child object dependencies are easily viewable within the documentation. This makes it easy for you to quickly understand the complexity of your SQL Objects so that you can make educated decisions when planning changes.

Object Dependencies Included

  • Both parent and child object dependencies are easily viewable within the documentation. This makes it easy for you to quickly understand the complexity of your SQL Objects so that you can make educated decisions when planning changes.

SQL Server Database Documentation step 4

Best Practice Analyzer

  • Developed by SQL Server MVPs, BI Documenter’s Best Practice Analyzer displays recommendations and alerts for potential performance issues related to the Database in question. The list of recommendations includes database level settings, missing primary keys, missing clustered indexes, and more.

Best Practice Analyzer

  • Developed by SQL Server MVPs, BI Documenter’s Best Practice Analyzer displays recommendations and alerts for potential performance issues related to the Database in question. The list of recommendations includes database level settings, missing primary keys, missing clustered indexes, and more.

SQL Server Database Documentation step 5

Data Quality Profiler

  • BI Documenter’s Data Quality Profiler allows you the option to include statistical data for each column (where applicable) in a table. Current profile data include %NULL, Min Value, Max Value, and %Unique.

Data Quality Profiler

  • BI Documenter’s Data Quality Profiler allows you the option to include statistical data for each column (where applicable) in a table. Current profile data include %NULL, Min Value, Max Value, and %Unique.

SQL Server Database Documentation step 6

Document Sample Data

  • Find out what your data looks like without actually needing to access the data source. Document Sample Data allows BI Documenter users the option to include a random selection of data from each table of a SQL Server Database as a reference when viewing the documentation.

Document Sample Data

  • Find out what your data looks like without actually needing to access the data source. Document Sample Data allows BI Documenter users the option to include a random selection of data from each table of a SQL Server Database as a reference when viewing the documentation.

View Our Suite of Pragmatic Works Products
js
Copyright 2014 by Pragmatic Works