#database-migration — Public Fediverse posts

After 7 major replatformings over 11 years, I've cataloged 5 hidden failure modes that silently break database migrations weeks after everyone stops watching. https://hackernoon.com/why-most-database-migrations-fail-silently-5-hidden-failure-modes-in-zero-downtime-replatforming #databasemigration

A clear, step-by-step guide to migrating a SQL Server database, including exporting schema, copying data, and rebuilding TestDB on a new server. https://hackernoon.com/how-to-migrate-an-sql-server-database-a-complete-step-by-step-guide #databasemigration

Hướng dẫn quản lý migration DB an toàn giữa dev và prod: dùng file SQL tuần tự, script migrate.sh chung, status.json theo dõi trạng thái, xác nhận trước, backup, thử nghiệm trên dev trước prod. Giảm rủi ro, kiểm soát thay đổi. #DatabaseMigration #DevOps #SQL #ORM #Migrations #Dev #Prod #Tech #CôngNghệ #CSDL #DiChuyểnDữLiệu

https://dev.to/pipipi-dev/database-migration-safely-managing-dev-and-production-environments-2nfh

Support for MySQL 5.7 ended 2 years ago, yet many sites still use it. Read this article for help with migrating a Drupal site to MySQL 8: risks involved, upgrade process and why backups and tests are your most valuable safeguard.

https://metadrop.net/en/articles/migrating-drupal-mysql-57-mysql-8

#MySQL #DatabaseMigration

Discover how to master OpenUpgrade Odoo Community migration with our comprehensive guide. Follow our 7 proven steps to seamlessly upgrade your database from version 16 to 18. #OdooMigration #OpenUpgrade #DatabaseMigration #OdooCommunity

https://teguhteja.id/openupgrade-odoo-community-migration-guide/

Need to migrate your Odoo database? Our comprehensive guide walks you through the Odoo database migration process from start to finish. Learn how to upgrade to Odoo 18 with ease. #Odoo #DatabaseMigration #Odoo18 #TechTutorial

https://teguhteja.id/odoo-database-migration-guide/

What database migration tool is most popular these days?

I am looking for framework, language and database agnostic migration tool.

I've used $DBMate in past. This is framework agnostic but isn't database agnostic. Raw SQL is needed for the migrations which can be slightly different for some databases.

#database #dba #databasemigration #software #python #golang #rust #php