Online Data Migration from SQL Server to Cloud Spanner using Striim

This post will focus on the implementation of a continuous migration from SQL Server to Cloud Spanner using Striim. The explanation will include steps for configuring and initial load and a continuous data replication using Change Data Capture. this is enablement post and doesn't talk about a full scale database migration and its challenges. This … Continue reading Online Data Migration from SQL Server to Cloud Spanner using Striim

Automated Database Backups for Cloud Spanner using Terraform

This post shows how to use cloudspannerecosystem/scheduled-backups to configure scheduled backups for your cloud spanner database. The setup of the required resources (cloud scheduler, pub\sub and cloud function) will be done by using terraform in this tutorial. The Architecture is as follows: We will provision the following GCP services using terraform: Cloud Scheduler: trigger tasks … Continue reading Automated Database Backups for Cloud Spanner using Terraform

Running SQL Server 2019 on Google Kubernetes Engine

Have you tried to run a SQL Server deployment on Google Kubernetes Engine yet? Here is a complete guide to create and run SQL Server 2019 on GKE. You will be creating the following resources to successfully host SQL Server on GKE. A namespace to host resources for SQL Server deploymentA secret for 'sa' accountPersistent … Continue reading Running SQL Server 2019 on Google Kubernetes Engine