database migration Archives - ITFROMZERO

A Guide to Automating MySQL Database Schema Migrations with Liquibase and CI/CD

By IT From Zero October 15, 2026

Ditch manual midnight SQL script deployments. Learn how to track MySQL schema changes with Liquibase and build safe CI/CD pipelines without table locks or drift.

MySQL

How to Use Flyway for MySQL Schema Migration and Version Control in CI/CD

By IT From Zero October 3, 2026

Learn how to use Flyway to automate schema migrations and version control for MySQL databases. Eliminate schema drift during deployments and integrate safely into your CI/CD pipeline.

Python

A Guide to Using Alembic in Python: Database Migration Management for SQLAlchemy

By IT From Zero October 2, 2026

Managing database schema changes is critical as Python projects scale. Here is a comprehensive guide to setting up Alembic with SQLAlchemy to automate migrations, sync via Git, and perform safe rollbacks.

MySQL

Migrating PostgreSQL to MySQL: Hard-won Lessons and a Real-world Workflow

By IT From Zero September 17, 2026

A step-by-step guide to the PostgreSQL to MySQL migration process, covering data type discrepancies and SQL syntax fixes to ensure data integrity.

MySQL

Migrating MSSQL to MySQL: Pro Tips for Troubleshooting and Data Type Mismatches

By IT From Zero September 3, 2026

Migrating MSSQL to MySQL is more than just clicking a button. This guide helps you resolve DATETIME2 and NVARCHAR(MAX) errors and use bcp for high-speed data migration.

Database

Database Version Control with Liquibase: Automating CI/CD and ‘Painless’ Rollbacks

By IT From Zero June 9, 2026

Manual database management is the fastest route to a deployment disaster. Discover how to use Liquibase to automate migrations and secure your data just like you manage code with Git.

Database

Atlas (Ariga): Database Schema Management as Code and Migration Automation

By IT From Zero May 21, 2026

Atlas (Ariga) enables IaC-style database schema management: describe your desired state, auto-generate migrations, lint destructive changes, and detect drift between code and your live database. This article compares Atlas with Flyway/Liquibase and walks through a real-world PostgreSQL setup.

Database

Migrating Data from MySQL to PostgreSQL: Comparing Methods and Practical Guide

By IT From Zero March 29, 2026

A guide comparing 3 methods for migrating data from MySQL to PostgreSQL: pgloader, manual mysqldump conversion, and Python ETL. Analyzes the pros and cons of each approach with practical command examples and a post-migration verification checklist.