mysql-postgresql-converter
A Python script for converting MySQL database dumps to PostgreSQL format, originally developed for Lanyrd's migration.
What is mysql-postgresql-converter?
Lanyrd's MySQL to PostgreSQL converter is a Python script that transforms MySQL database dumps into PostgreSQL-compatible format. It was specifically created to handle Lanyrd's migration from MySQL to PostgreSQL, addressing unicode character size issues and foreign key indexing requirements. The tool assumes Django's column typing conventions for accurate type mapping during conversion.
Django developers and database administrators who need to migrate MySQL databases to PostgreSQL, particularly those with unicode character requirements and foreign key relationships.
This converter provides a battle-tested solution that handles specific edge cases encountered in production migrations, particularly unicode character size adjustments and automatic foreign key indexing that aren't always addressed by generic conversion tools.
Overview
Lanyrd's MySQL to PostgreSQL conversion script
Use Cases
Best For
- Migrating Django applications from MySQL to PostgreSQL
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
