DEV Community

Discussion on: What's Your Approach to Data Migration & Database Versioning?

Collapse
 
bbkr profile image
Paweł bbkr Pabian

For those who need to migrate single users between complex database schemas - you can try my UpRooted project. It allows to extract data tree starting from given row in given table and feed into another database or save to file. Currently MySQL and PostgreSQL are supported, but any other relational engine can be easily added.

Very useful on major DB upgrades to avoid big bang deploys of all users at once and for shard balancing after hardware purchases.