SQL Server
Solution Item Icon | Solution Item Description |
---|---|
![]() | 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.
2. Select Add to open the Add Solution item window.
3. Enter an item name, and then select SQL Server 2005 - 2019 from the Source type drop-down list.
4. Select SQL Server, or SQL Azure, and then enter a valid server name and connection credentials.
![]() | ![]() |
5. Select OK to add the SQL Server Solution item to your SentryOne Document Solution.
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.
![]() Sample SQL Server Table Documentation
| ![]() Sample SQL Server Table Column Documentation
| ![]() 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 Table Lineage example
|
Display more granular lineage for table columns, foreign keys, and indexes.
SentryOne Document SQL Server Database Table Column Lineage example
Additional Information: For more information about the Lineage tab in SentryOne Document, see the Lineage article.