Applies to: Azure SQL Database
This article provides an overview of the local development experience tailored for Azure SQL Database.
OverviewThe Azure SQL Database local development experience is a combination of tools and services that empowers application developers and database professionals to design, build, validate, and publish database schemas for databases while working offline.
The following diagram illustrates the inner and outer loop processes in the development lifecycle, highlighting how developers interact with Azure SQL Database both locally and in the cloud:
Let's understand both the inner and outer loop in detail:
Inner loopThe inner loop represents the local development cycle. It's where developers write code, test it, and debug it on their local machines.
During this phase, developers interact with a local instance of SQL Database. They can quickly iterate on their code with immediate feedback, without needing to deploy changes to the cloud.
The goal of the inner loop is to enable rapid development and testing in an isolated environment that closely mimics the production setup.
The outer loop encompasses the broader development lifecycle, including collaboration, continuous integration, and deployment to production.
Changes made in the inner loop are pushed to a shared repository, such as a GitHub repository, where they can be reviewed, tested, and merged.
From the repository, automated workflows (for example, through GitHub Actions or GitHub Codespaces) build and deploy the application, including any database changes, to Azure services.
In the outer loop, the application and database are deployed to Azure, where they can be accessed and used in a live environment.
To streamline the local development experience, several tools and extensions are available. The following table provides a high-level overview of these options, each tailored for different aspects of the development lifecycle.
Azure SQL Database Dev Container templatesDev containers offer a streamlined, preconfigured development environment for Azure SQL Database, eliminating the need for manual setup. These containers enhance productivity by ensuring that all necessary tools and dependencies are available right from the start.
Developers can utilize dev containers to quickly start coding in environments that mimic the Azure SQL Database setup, promoting consistency across local and cloud development. This approach not only accelerates the development process but also reduces errors and ensures a smooth transition from local development to production deployment.
To learn more about the Azure SQL Database Dev Container Templates, see What are the Dev Container Templates for Azure SQL Database?
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4