Build and Publish a project

  • 2 minutes to read

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

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.

Next steps