Publish a Database Project for Azure SQL Database to the local emulator

Applies to: Azure SQL Database

This article provides steps to build and publish a Database Project to the Azure SQL Database emulator (preview).

Overview

The Azure SQL Database local development experience allow users to source control Database Projects and work offline when needed. The local development experience uses the Azure SQL Database emulator, a containerized database with close fidelity with the Azure SQL Database public service, as runtime host for Database Projects that can be published and tested locally as part of developer's inner loop. This article describes how to publish a Database Project to the local emulator.

Prerequisites

Before you can publish a Database Project to the local emulator, you must:

Build and publish a Database Project

You must first build your Database Project before publishing. To complete this process:

  1. First, follow the steps in Build a Database Project.
  2. Then follow the steps in Publish the SQL project and deploy to a local Container.

Next steps

Learn more about the local development experience for Azure SQL Database: