Introducing Py-Auto-Migrate: Database Migration Made Simple
Source: Dev.to
Honestly, sometimes migrating between databases during a project is difficult. For example, transferring tables between relational databases or transferring data between a relational database and a NoSQL database. That’s why I built Py-Auto-Migrate. Py-Auto-Migrate is an open source tool that automatically transfers data between different database systems. Simply provide a source and target database, and the tool will: Detect schemas automatically Map data types between databases Create missing tables and databases Migrate data with minimal configuration pip install py-auto-migrate
Example:
py-auto-migrate migrate
—source “mongodb://user:pass@localhost:27017/source_db”
—target “mysql://user:pass@localhost:3306/target_db”
Supports SQL and NoSQL databases Automatic schema detection and creation Migrate a single table or an entire database AI-powered filtering and querying using natural language (only relational databases) Web dashboard MySQL PostgreSQL Oracle SQL Server MariaDB SQLite MongoDB Redis DynamoDB Elasticsearch ClickHouse For users who prefer a GUI, Py-Auto-Migrate includes a dashboard: py-auto-migrate dashboard
⚠️ Py-Auto-Migrate is still in its early stages and should not be considered a fully stable release yet. GitHub: https://github.com/kasrakhaksar/py-auto-migrate PyPI: https://pypi.org/project/py-auto-migrate/