Skip to content

Database project tools

Jump to bottom
Erik Ejlskov Jensen edited this page May 12, 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.

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

Clone this wiki locally