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
Tag: spanner
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