Visual Studio Tools to enhance the SQL Database Projects developer experience.
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
- Unpack dacpac - extract a .dacpac into a single .sql file
In addition, an extension pack for SQL Database Project Power Tools is available, which includes:
- SQL Database Project Power Tools from ErikEJ
- T-SQL Analyzer from ErikEJ
- SQL Formatter from Mads Kristensen
