py-auto-migrate 0.2.0

A Tool For Transferring Data, Tables, And Datasets Between Different Databases.

𝐏𝐲-𝐀𝐮𝐭𝐨-𝐌𝐢𝐠𝐫𝐚𝐭𝐞

A powerful database migration tool to transfer data (e.g., between MongoDB and MySQL or PostgreSQL and MySQL), with automatic table/database creation, existence checks, and support for full database migrations.

---

Installation

pip install py-auto-migrate

Download CLI

If you don’t have Python, or you want to use it with the CLI (Shell), you can download the dedicated PAM-CLI from the Releases on GitHub epository.

---

Help

py-auto-migrate --help

This command displays a detailed guide on how to use the package, including available commands, arguments, and examples. It’s the best place to start if you want to quickly understand how to work with py-auto-migrate.

---

Usage

Command Line Interface (CLI)

py-auto-migrate migrate --source <source_uri> --target <target_uri> --table <table_name>

--source :Source database URI (e.g., mysql://user:pass@host:3306/dbname)

--target :Target database URI (e.g., mongodb://localhost:27017/mydb)

--table (optional):Specific table/collection to migrate. If omitted, all tables/collections will be

---

Example

py-auto-migrate migrate --source "mongodb://localhost:27017/mydb" --target "mongodb://localhost:27017/mydb2"

py-auto-migrate migrate --source "mongodb://localhost:27017/mydb" --target "mysql://root:1234@localhost:3306/mydb" --table users

You can also use MongoDB → MongoDB or PostgreSQL → PostgreSQL

---

Database Support

• MySQL
• MongoDB
• PostgreSQL
• MariaDB
• SQL Server
• SQLite

---

Future Plans

• Add support for creating indexes on tables/collections to improve query performance.
• Support for more databases: Add migrations for Oracle.