py-auto-migrate 0.2.1

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 Shell

If you don’t have Python, or you want to use it with the Shell, you can download the dedicated PAM-Shell 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>

Argument	Description
--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 migrated.

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

---

Supported Databases

Database
MySQL
PostgreSQL
MongoDB
MariaDB
Oracle
SQL Server
SQLite

---

Future Plans

Feature	Status
Index creation on tables/collections	Planned
Support for Oracle migrations	✔️
Performance optimizations for large datasets	Planned