SQL Database Project Power Tools

Download this extension from the Visual Studio Marketplace or get the CI build

---

Visual Studio Tools to enhance the SQL Database Project developer experience.

Overview blog post: SQL Project Power Tools for Visual Studio

Features

The tool contains the following features.

• Templates - for use with New Project and for adding new items
• Import database - import the schema and database settings from an existing database
• Schema compare - compare your database project with a live database and get a script to update the database or your project
• Analyze - report with static code analysis result of your database project
• Create Mermaid E/R diagram - create an Entity/Relationship diagram of selected tables from your database project
• Script Database Model - extract a .dacpac into a single .sql file
• Script Table Data - generate insert statements for table data in your database project, based on generate-sql-merge

Power Pack

I have also published SQL Project Power Pack which adds additional features.

• T-SQL Analyzer - live code analysis of your T-SQL object creation code for design, naming and performance issues using more than 140 rules.
• SQL Formatter - formats T-SQL code to a consistent and readable layout with .editorconfig support.

Advanced topics

Have a look at our extensive user guide for more information on topics like:

• reference user and system databases
• set database and build properties
• use pre- and post-deployment scripts
• pack and publish dacpacs
• use sqlcmd variables
• static code analysis customization
• and much more

How can I help?

If you enjoy using the extension, please give it a ★★★★★ rating on the Visual Studio Marketplace.

Should you encounter bugs or have feature requests, head over to the GitHub repo to open an issue if one doesn't already exist.

Another way to help out is to sponsor me on GitHub.

If you would like to contribute code, please fork the GitHub repo and submit a pull request.