Get your SQL Server dev environment ready in one click
Setting up a development environment is – most of the time – cumbersome. Technologies like Docker and Visual Studio Code Remote Containers – and GitHub Codespaces – really help a lot. We’ve just released a new sample, Try Out Development Containers: SQL Server & Azure SQL that get you ready to work on your databases projects, just in one click!
One-click to SQL Server development
If you click on the button below, you will open an instance of Visual Studio Code – if it’s installed – spin up a new SQL server instance and automatically add relevant Visual Studio Code extensions.
When you have opened this template, you can directly write SQL files, execute them either through the SQLCMD CLI or use the SQL Server extension to visualize your database right from the Visual Studio Code interface. You have everything ready to work on your database projects.
Easily deploy database schema changes
This sample uses the SQL Database Projects extension. This extension allows you to organize your SQL files into a database project. This extension allows you to:
- Create a database schema from a Swagger or Open API definition
- Compare your database to your database numbers
- Deploy your database project to an Azure SQL database or a SQL Server instance
Use it for learning or for your next project
You can use this Dev Container quick start simply to learn how to use Azure SQL or SQL Server. But you can also simply Use this Template within GitHub to create your next database project and get everything already setup for you.
Citation
For attribution, please cite this work as
Maneu (2022, October 25). maneu.net: Get your SQL Server dev environment ready in one click. Retrieved from https://www.maneu.net/data/azure-sql-server-dev-environment-one-click-devcontainers/
@misc{ azure-sql-server-dev-environment-one-click-devcontainers,
author = {Maneu, Christopher},
title = { Get your SQL Server dev environment ready in one click },
url = { https://www.maneu.net/data/azure-sql-server-dev-environment-one-click-devcontainers/ },
year = { 2022 }
}