sábado, 3 de junio de 2023

Configure your local sandbox database container from your Azure environment in Azure SQL

Blog - Configure your local sandbox.md

Configure a local sandbox DB from an AZ environment

Sometimes we need to create a sandbox environment to do some testing before we push it into our company main Dev repository, we need to do some unit testing while developing our database changes; to do so we need to replicate the testing environment to have it in our local machines. In the following note we will work with a cloud database from an Azure SQL that is in a serverless tier and will create a copy, prepare it for our container environment testing, connect it, and do some local tasks to poor in some data tests inside it.

These are the steps that will be followed to complete the task: