Tag: Database Migration
Azure Synapse Analytics: an Unusual Introduction
This post is a 101 introduction to Azure Synapse including information that it is not easily found in the online documentation and courses.
Data Validation and Reconciliation
Ensure data quality when copying, migrating, loading, replicating or moving data with data validation rules and reconciling records.
A brief introduction to BigQuery’s architecture
This post helps to understand BigQuery’s internal design and how efficiently to load, replicate or migrate data into it.
Data Replication & Qlik Replicate
This post explains what Data Replication is and how it differentiates from ETL/ ELT, what Change Data Capture (CDC) is, and a few Qlik Replicate use cases.
PostgreSQL Database Cluster Inventory
We share in this post our own scripting to make an inventory of a PostgreSQL database: cluster information, objects and permissions. We’ve used these scripts to plan for migrations.
Migration from PostgreSQL to MongoDB on AWS
This post explains how to differentiate among the different types of NoSQL databases. and how to plan a migration from PostgreSQL to MongoDB.