A database project is a structured collection of SQL scripts and query files designed for creating new databases or updating existing ones. These projects can be initiated from scratch or created based on the existing databases, providing a range of features that facilitate efficient database development.
Database Projects | SQL Server | MySQL and MariaDB | Oracle | PostgreSQL |
---|---|---|---|---|
New project wizard with import from an existing database | ||||
Project Explorer window for managing project files | ||||
Schema View window for browsing logical project structures | ||||
Project export to one of the multiple scripts | ||||
Multiple build configurations | ![]() |
|||
Single-click project deployment on the server | ||||
Comparison of projects with live databases |