Udostępnij za pośrednictwem


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

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

Important

Set up a development environment with an Azure SQL Database dev container template. To get started, set up an Azure SQL Database local development environment with an dev container template. Dev container templates are a superior alternative and replacement to the Azure SQL Database emulator for local development.

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: