Database Projects

Last modified: September 6, 2024

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 NO YES YES NO
Project Explorer window for managing project files NO YES YES NO
Schema View window for browsing logical project structures NO YES YES NO
Project export to one of the multiple scripts NO YES YES NO
Multiple build configurations NO YES YES no
Single-click project deployment on the server NO YES YES NO
Comparison of projects with live databases NO YES NO NO