Documentation forDatabase Mapper
Effective February 28, 2024, Database Mapper has reached its end of life and is no longer available or supported. If you liked Database Mapper, consider trying another SolarWinds product.

Database Mapper SQL Server

EOL: An end of life announcement has been made for Database Mapper on February 28, 2023. See the Solarwinds End of Life Policy for more information.

SQL Server 

Solution Item Icon Solution 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 openan 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.

  • Select SQL Server, and enter a valid server name and connection credentials.

  • Select Azure SQL , and enter a valid server name and connection credentials.

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

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 openan 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.

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.

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

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.

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

Database Mapper SQL Server Database Table Column Lineage example

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