Database Mapper SQL Server
SQL Server
Solution Item Icon | Solution Item Description |
---|---|
![]() |
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.
2. Select Add to open the Add Solution item window.
3. Enter an item name, and then select SQL Server 2008+, Azure SQL & DacPac from the Source type drop-down list.
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.
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.
2. Select Add to open the Add Solution item window.
3. Enter an item name, and then select SQL Server 2005 - 2019 (Legacy SMO) 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 2005 - 2019 (Legacy SMO) Solution item to your Database Mapper 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.
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.
Additional Information: For more information about the Lineage tab in Database Mapper, see the Lineage article.