πŸ‘‹ Hey, I'm currently migrating my blog, some articles are still underway. Thanks for your patience!
[email protected]:/dev/$ more azure-sql-server-dev-environment-one-click-devcontainers

Get your SQL Server dev environment ready in one click

Date:
2 minutes reading

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.

Open in Remote - Containers

Visual Studio Code opened on the Try SQL CMD project

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

Visual Studio Code UI to publish schema changes to a database

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

Share
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/

BibTeX citation
@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 }
}