Database Mapper SQL Server

Update: SentryOne Document is now SolarWinds Database Mapper (DMR). See the Database Mapper product page to learn more about features and licensing. Want to explore Database Mapper? An interactive demo environment is available without any signup requirements.

SQL Server 

Solution Item IconSolution Item Description
Database Mapper SQL Server Provider

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

Adding SQL Server 2008+, Azure SQL & DacPac

The SQL Server 2008+, Azure SQL & DacPac Solution item allows you to snapshot a single SQL Database, a .dacpac file, or your entire SQL Server or Azure SQL environments. The SQL Server 2008+, Azure SQL & DacPac Solution item is available for Database Mapper Versions 2021.12 and above, and allows you to snapshot your SQL Server objects much faster than the SQL Server 2005 - 2019 (Legacy SMO) solution item.

Add a SQL Server 2008+, Azure SQL & DacPac Solution item to your Database Mapper Solution by completing the following steps:

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

2. Select Add to open the Add Solution item window. Database Mapper Solution Configuration Tool Add Solution Item

3. Enter an item name, and then select SQL Server 2008+, Azure SQL & DacPac from the Source type drop-down list.Database Mapper Add Solution Item SQL Server 2008+, Azure SQL & DacPac

4. Choose one of the following options:

Select SQL Database, enter a valid server name and connection credentials, and then select your database.Database Mapper add solution item SQL Server 2008+, Azure SQL & DacPac SQL Database credentials
SQL Database






Select SQL Server, and enter a valid server name and connection credentials.Database Mapper add solution item SQL Server 2008+, Azure SQL & DacPac SQL Server credentials
SQL Server






Select Azure SQL , and enter a valid server name and connection credentials.Database Mapper add solution item SQL Server 2008+, Azure SQL & DacPac Azure SQL credentials
Azure SQL






Select DacPac, and enter a valid .dacpac file connection string.

Note:  You can select the to search for a valid .dacpac file.
Database Mapper add solution item SQL Server 2008+, Azure SQL & DacPac .dacpac file
DacPac

5. Select OK to add the SQL Server 2008+, Azure SQL & DacPac Solution item to your Database Mapper Solution.

Database Mapper Add Solution Item SQL Server 2008+, Azure SQL & DacPac select Ok

 Adding SQL Server 2005 - 2019 (Legacy SMO) 

Add a SQL Server 2005 - 2019 (Legacy SMO) Solution item to your Database Mapper Solution by completing the following steps:

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

2. Select Add to open the Add Solution item window. Database Mapper Solution Configuration Tool Add Solution Item

3. Enter an item name, and then select SQL Server 2005 - 2019 (Legacy SMO) from the Source type drop-down list.Database Mapper Add Solution Item SQL Server 2005 - 2019 (Legacy SMO)

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

Database Mapper Add Solution Item SQL Server 2005 - 2019 (Legacy SMO) SQL Server credentials
Database Mapper Add Solution Item SQL Server 2005 - 2019 (Legacy SMO) SQL Azure credentials

5. Select OK to add the SQL Server 2005 - 2019 (Legacy SMO) Solution item to your Database Mapper Solution.Database Mapper Add Solution Item SQL Server 2005 - 2019 (Legacy SMO) 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.

Database Mapper SQL Server Table Documentation example
Sample SQL Server Table Documentation
Database Mapper SQL Server Table Column Documentation example
Sample SQL Server Table Column Documentation
Database Mapper SQL Server Foreign Key Documentation example
Sample SQL Server Foreign Key Documentation

Additional Information: For more information about the Documentation tab in Database Mapper, 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.

Database Mapper SQL Server Database Lineage example
Database Mapper SQL Server Database Lineage example

Database Mapper SQL Server Database Table Lineage example
Database Mapper SQL Server Database Table Lineage example

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

Database Mapper SQL Server Database Table Column Lineage exampleDatabase Mapper SQL Server Database Table Column Lineage example

Additional Information: For more information about the Lineage tab in Database Mapper, see the Lineage article.