SentryOne Document SQL Server

SQL Server

Solution Item IconSolution Item Description
SentryOne Document SQL Server Provider

SentryOne Document allows you to document databases across major versions of SQL Server. See the System Requirements article for details on prerequisites.

Adding SQL Server

Add a SQL Server Solution item to your SentryOne Document Solution by completing the following steps:

1. Select Add to add a new Solution, or select Open to open an existing solution in the SentryOne Document Configuration tool. SentryOne Document Solution Configuration Tool Open Solution

2. Select Add to open the Add Solution item window. SentryOne Document Solution Configuration Tool Add Solution Item

3. Enter an item name, and then select SQL Server 2005 - 2019 from the Source type drop-down list.SentryOne Document Add Solution Item SQL Server 2005-2019

4. Select SQL Server, or SQL Azure, and then enter a valid server name and connection credentials.

SentryOne Document Add Solution Item SQL Server credentials
SentryOne Document Add Solution Item SQL Azure credentials

5. Select OK to add the SQL Server Solution item to your SentryOne Document Solution.SentryOne Document Add Solution Item SQL Server select Ok

Important:  Non-sysadmin users must be granted View Server State permissions to view log file objects within the documentation.

SQL Server Solution Item Sample Documentation

Additional Information: You need to take a snapshot of your Solution and SQL Server Solution item before viewing any documentation or lineage. For more information about taking a snapshot, see the Generating Documentation and Scheduling a Snapshot articles.

After adding a Solution with your SQL Server Solution Item, and taking a snapshot, you are ready to view your documentation. View your SQL Servers and their databases.Sample SQL Server Database Documentation

View database tables and more granular information such as table columns, or foreign keys.

SentryOne Document SQL Server Table Documentation example
Sample SQL Server Table Documentation
SentryOne Document SQL Server Table Column Documentation example
Sample SQL Server Table Column Documentation
SentryOne Document SQL Server Foreign Key Documentation example
Sample SQL Server Foreign Key Documentation

Additional Information: For more information about the Documentation tab in SentryOne Document, see the Documentation article.

SQL Server Solution Item Sample Lineage

After adding a Solution with your SQL Server Solution Item, and taking a snapshot, you are ready to view your Solution's lineage within the environment.  Lineage provides some of the same options on the nodes, but displays graphs and dependency flows of the information and connections. You can adjust the granularity or apply filters. 

Display lineage for your SQL Server Databases and Database tables.

SentryOne Document SQL Server Database Lineage example
SentryOne Document SQL Server Database Lineage example

SentryOne Document SQL Server Database Table Lineage example
SentryOne Document SQL Server Database Table Lineage example

Display more granular lineage for table columns, foreign keys, and indexes.

SentryOne Document SQL Server Database Table Column Lineage exampleSentryOne Document SQL Server Database Table Column Lineage example

Additional Information: For more information about the Lineage tab in SentryOne Document, see the Lineage article.