Skip to content

Database project tools

Erik Ejlskov Jensen edited this page Aug 5, 2024 · 4 revisions

The database project tools are a set of tools to enhance your development experience with Database projects in Visual Studio. In addition to the traditional SQL Database project (.sqlproj) projects, projects based on the MSBuild.SDK.SqlProj SDK are supported.

Right click the database project in Solution Explorer and select a tool:

Analyze this! (preview)

Runs T-SQL static code analysis against your database project, and displays the results in html format. If you want to add this to your database project during build, follow the guide in my blog post. Thanks to the SqlServer.Rules project for sharing the building blocks for this feature.

Visualize Database Model

Allows you to visualize the schema of the chosen database project. Requires the Visual Studio DGML viewer component (not available for ARM64)

Generate ER Diagram

Generate a Mermaid ER diagram of your database project. Requires the Mermaid editor extension