How to add my Azure sql db as a container in Azure Container Registry?

Elliot Stansfield 1 Reputation point
2023-04-25T09:40:54.22+00:00

I'm fairly new to the concept of containers and Azure Container Registry, I ideally would like to take my existing Azure SQL DB, create a container from it and add it into ACR so I can use it as part of Azure Container Instance/ AKS. What would be the easiest way of achieving this?

Azure SQL Database
Azure Container Registry
Azure Container Registry
An Azure service that provides a registry of Docker and Open Container Initiative images.
416 questions
Azure Container Instances
Azure Container Instances
An Azure service that provides customers with a serverless container experience.
663 questions
{count} votes

1 answer

Sort by: Most helpful
  1. shiva patpi 13,156 Reputation points Microsoft Employee
    2023-04-25T21:20:32.5233333+00:00

    @Elliot Stansfield Probably your question or ask is not clear !! But based upon your requirements it's not possible. You can't just create a container out of Azure SQL DB .

    ACR is mainly used to store the container images through which a container can be created.

    If you want to deploy a SQL Server as a container in AKS you can use the steps mentioned below:

    https://learn.microsoft.com/en-us/sql/linux/quickstart-sql-server-containers-kubernetes?view=sql-server-ver16

    -> Create a Persistent Volume (To store the data in azure disk)

    -> Create a pod by using sql server Image: mcr.microsoft.com/mssql/server:2019-latest

    -> expose the pod using a service

    -> You can connect to that containerized pod using SQL server management studio using the serviceIP.

    Regards,

    Shiva.

    0 comments No comments