Posted inMySQL
Migrating PostgreSQL to MySQL: Hard-won Lessons and a Real-world Workflow
A step-by-step guide to the PostgreSQL to MySQL migration process, covering data type discrepancies and SQL syntax fixes to ensure data integrity.
Posted inMySQL
Migrating MSSQL to MySQL: Pro Tips for Troubleshooting and Data Type Mismatches
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.
Posted inDatabase
Database Version Control with Liquibase: Automating CI/CD and ‘Painless’ Rollbacks
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.
Posted inDatabase
Atlas (Ariga): Database Schema Management as Code and Migration Automation
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.
Posted inMySQL
Migrating MySQL to Amazon RDS and Google Cloud SQL: Real-World Experience from Large Projects
A hands-on guide to migrating MySQL to Amazon RDS and Google Cloud SQL. Includes optimization commands, connection troubleshooting, and tips to avoid downtime.
Posted inDatabase
Migrating Data from MySQL to PostgreSQL: Comparing Methods and Practical Guide
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.