---
title: "#database-migrations articles | Hashnode"
description: "Explore 31 articles tagged #database-migrations on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/database-migrations"
---

Tag

# #database-migrations

31 posts · 1 followers

[Ejaz Arain](https://hashnode.com/@ejazarain) · [Nov 13](https://hashnode.com/posts/a-cast-to-five-bytes-and-a-two-character-word/6af6d3bbe9abe11193821938)

### [A cast to five bytes and a two-character word](https://rutba.hashnode.dev/a-cast-to-five-bytes-and-a-two-character-word?utm_source=hashnode&utm_medium=feed)

First published on the Tech Style blog. CAST('中文' AS VARCHAR2(5)) asks for five bytes of a value that takes six. Each of the two characters is three bytes long in a UTF-8 database, so the fifth byte f

3 min read · [rutba.hashnode.dev](https://rutba.hashnode.dev/a-cast-to-five-bytes-and-a-two-character-word?utm_source=hashnode&utm_medium=feed)

[Ejaz Arain](https://hashnode.com/@ejazarain) · [Nov 6](https://hashnode.com/posts/paritas-an-oracle-compatible-database-built-on-postgresql-that-tells-you-where-compatibility-ends/6aedc62890d9e8e06386310e)

### [Paritas: an Oracle-compatible database built on PostgreSQL that tells you where compatibility ends](https://rutba.hashnode.dev/paritas-an-oracle-compatible-database-built-on-postgresql-that-tells-you-where-compatibility-ends?utm_source=hashnode&utm_medium=feed)

Paritas is PostgreSQL 18 with an Oracle mode. How we test it against a real Oracle, and our list of where compatibility ends.

5 min read · [rutba.hashnode.dev](https://rutba.hashnode.dev/paritas-an-oracle-compatible-database-built-on-postgresql-that-tells-you-where-compatibility-ends?utm_source=hashnode&utm_medium=feed)

[Ejaz Arain](https://hashnode.com/@ejazarain) · [Nov 2](https://hashnode.com/posts/pgrecon-an-oracle-to-postgresql-assessment-that-never-connects-to-your-database/6ae8607ac317c5fbc1f99967)

### [pgrecon, an Oracle to PostgreSQL assessment that never connects to your database](https://rutba.hashnode.dev/pgrecon-an-oracle-to-postgresql-assessment-that-never-connects-to-your-database?utm_source=hashnode&utm_medium=feed)

A free, open-source Oracle to PostgreSQL assessment. It reads files a DBA hands over, never the database, and names each problem by object and line.

4 min read · [rutba.hashnode.dev](https://rutba.hashnode.dev/pgrecon-an-oracle-to-postgresql-assessment-that-never-connects-to-your-database?utm_source=hashnode&utm_medium=feed)

[Diwakar Exe](https://hashnode.com/@diwakarexe) · [Aug 26](https://hashnode.com/posts/securing-sensitive-financial-records-during-microsoft-azure-migration-with-azure-data-migration-service/6a8eafd1725f4961561708e9)

### [Securing Sensitive Financial Records During Microsoft Azure Migration with Azure Data Migration Service](https://techspades.hashnode.dev/securing-sensitive-financial-records-during-microsoft-azure-migration-with-azure-data-migration-service?utm_source=hashnode&utm_medium=feed)

Learn how Azure Data Migration Service helps secure sensitive financial records during Microsoft Azure migration with data protection strategies

4 min read · [techspades.hashnode.dev](https://techspades.hashnode.dev/securing-sensitive-financial-records-during-microsoft-azure-migration-with-azure-data-migration-service?utm_source=hashnode&utm_medium=feed)

[Uttam Mahata](https://hashnode.com/@uttammahata) · [Jul 5](https://hashnode.com/posts/migrating-mongodb-data-to-atlas-a-practical-field-guide/6a49b98ca77b2198d4341314)

### [Migrating MongoDB Data to Atlas: A Practical Field Guide](https://uttammahata.hashnode.dev/migrating-mongodb-data-to-atlas-a-practical-field-guide?utm_source=hashnode&utm_medium=feed)

Learn how to migrate MongoDB to Atlas safely: dump/restore with merge vs. drop, filtered exports

8 min read · [uttammahata.hashnode.dev](https://uttammahata.hashnode.dev/migrating-mongodb-data-to-atlas-a-practical-field-guide?utm_source=hashnode&utm_medium=feed)

[Jeremy Longshore](https://hashnode.com/@jeremylongshore) · [Jul 1](https://hashnode.com/posts/making-a-youth-sports-app-coppa-compliant-the-real-process-from-question-to-production/6a449cc41b7a7db864846464)

### [Making a Youth Sports App COPPA-Compliant: The Real Process From Question to Production](https://jeremylongshore.hashnode.dev/making-a-youth-sports-app-coppa-compliant-the-real-process-from-question-to-production?utm_source=hashnode&utm_medium=feed)

When you're building an app that tracks data for children under 13, there's a moment where you realize: this needs to be legally bulletproof before it sees a single real user. For Hustle, our youth so

10 min read · [jeremylongshore.hashnode.dev](https://jeremylongshore.hashnode.dev/making-a-youth-sports-app-coppa-compliant-the-real-process-from-question-to-production?utm_source=hashnode&utm_medium=feed)

[Sagar Thosar](https://hashnode.com/@sagarthosar) · [May 20](https://hashnode.com/posts/oracle-to-aurora-postgresql-migration-gotchas-tags-oracle-dba-aws-rds-cloud-migration-database-aws/6a0d792e7e4b2e77c07a4df8)

### [Oracle to AWS PostgreSQL: The Migration Gotchas Nobody Puts in the Runbook](https://sagarthosar.hashnode.dev/oracle-to-aurora-postgresql-migration-gotchas-tags-oracle-dba-aws-rds-cloud-migration-database-aws?utm_source=hashnode&utm_medium=feed)

You have run SCT. DMS is configured. Full load completed. And then the application breaks in ways no migration guide warned you about. Here is that list.

19 min read · [sagarthosar.hashnode.dev](https://sagarthosar.hashnode.dev/oracle-to-aurora-postgresql-migration-gotchas-tags-oracle-dba-aws-rds-cloud-migration-database-aws?utm_source=hashnode&utm_medium=feed)

[Deploynix](https://hashnode.com/@deploynix) · [Apr 17](https://hashnode.com/posts/recovering-from-a-failed-database-migration-in-production/69e1b04664ff0e601787d420)

### [Recovering From a Failed Database Migration in Production](https://deploynix.hashnode.dev/recovering-from-a-failed-database-migration-in-production?utm_source=hashnode&utm_medium=feed)

You deploy your latest release. The deployment log is scrolling through your hooks, and then you see it: SQLSTATE\[42S21\]: Column already exists or worse, the migration runs halfway through and the process times out. Your database is now in a partiall...

9 min read · [deploynix.hashnode.dev](https://deploynix.hashnode.dev/recovering-from-a-failed-database-migration-in-production?utm_source=hashnode&utm_medium=feed)

[Payal Porwal](https://hashnode.com/@PayalPorwal) · [Feb 24](https://hashnode.com/posts/master-the-top-sql-queries-clear-explanations-practical-examples/699dac5276cf0888f4aef4d4)

### [Master the Top SQL Queries: Clear Explanations + Practical Examples](https://codeswithpayal.hashnode.dev/master-the-top-sql-queries-clear-explanations-practical-examples?utm_source=hashnode&utm_medium=feed)

1️⃣ SELECT (Basic Data Fetching) 🔹 What it does: Fetch data from a table. 🔹 Syntax: SELECT column1, column2 FROM table\_name; 🔹 Example: SELECT name, salary FROM employees; 🔹 Use Case: Showing u

5 min read · [codeswithpayal.hashnode.dev](https://codeswithpayal.hashnode.dev/master-the-top-sql-queries-clear-explanations-practical-examples?utm_source=hashnode&utm_medium=feed)

[Danny Crasto](https://hashnode.com/@danwald) · [Jan 23](https://hashnode.com/posts/missing-initial-migration/6973a83aed707fd6cd77883a)

### [Missing initial migration](https://blog.danwald.me/missing-initial-migration?utm_source=hashnode&utm_medium=feed)

Using the Flask-Migrate extension you can create database migrations for your application. Flask application’s typically auto-create db tables on start So running flask db upgrade you’ll get: INFO \[alembic.env\] No changes in schema detected. To cr...

1 min read · [blog.danwald.me](https://blog.danwald.me/missing-initial-migration?utm_source=hashnode&utm_medium=feed)
