Migrate a SQL Server database from Windows to Kubernetes

Moving to Cloud-based and Managed Infrastructure as a Service

This is a case based on my recent experience to reduce an infrastructure administration and management, and support variability in a client infrastructure requirements by deploying onto the cloud or infrastructure as a service.

Firstly, I will show you how to get a desired state to move on. So how to move a database.

Actual Scenario

The following scenario was found when I started:

A Windows machine with the following:

• SQL Server installed.
• Target database to migrate.

Desired Scenario

The desired scenario we are looking for is:

A SQL Server instance on Kubernetes in Google Cloud, with persistent storage for high availability (HA). These solution should be provides resiliency. If the SQL Server instance fails, Kubernetes automatically re-creates it in a new pod.

Background

In general, a container’s root filesystem is not suitable to store persistent data. The containers you run on Kubernetes Engine are typically disposable entities, and the…