Build and Publish a project
The build process in the SQL Database Projects extension for Azure Data Studio allows for dacpac creation in Windows, macOS, and Linux environments. The project can be deployed to a local or cloud environment with the publish process.
Prerequisites
- Install and configure SQL Database Projects extension for Azure Data Studio.
Build a Database Project
In the Projects viewlet under Explorer, right-click the .sqlproj root node and select Build.
The output pane will automatically appear with the output from the build process. A successful build will conclude with the message:
... exited with code: 0
Publish a Database Project
After a project is successfully compiled through the build process, the database can be published to a SQL Server instance. To publish a database project, in the Projects viewlet under Explorer, right-click the .sqlproj root node and select Publish.
In the Publish Database dialog that appears, specify a server connection and the database name to be created.