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:
- Follow the steps in Set up a local development environment for Azure SQL Database to configure your environment.
- Create a Database Project by following the steps in Create a SQL Database Project for a local Azure SQL Database development environment.
Build and publish a Database Project
You must first build your Database Project before publishing. To complete this process:
- First, follow the steps in Build a Database Project.
- 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:
- What is the local development experience for Azure SQL Database?
- Set up a local development environment for Azure SQL Database
- Create a Database Project for a local Azure SQL Database development environment
- Quickstart: Create a local development environment for Azure SQL Database
- Introducing the Azure SQL Database emulator