py-auto-migrate 0.3.5

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

🚀 Py-Auto-Migrate

The Universal Database Migration Tool
Seamlessly transfer data between any database.

---

⚡ Why Py-Auto-Migrate?

Migrating data between different database systems is often a tedious and error-prone task. Py-Auto-Migrate is here to change that. It's a powerful, flexible, and easy-to-use Python tool that automates the entire process.

• 🔌 Universal Connector: Supports a vast range of databases, from SQL to NoSQL.
• 🤖 Zero Configuration: Point to your source and target, and let the tool handle schema detection, data type mapping, and destination creation.
• ⚡ Blazing Fast: Optimized for performance, even with large datasets.
• 🛡️ Safe & Reliable: Built-in checks ensure data integrity throughout the migration.

---

📦 Installation

Get started in seconds with pip.

pip install py-auto-migrate

🐚 Prefer a Standalone Shell?

Don't have Python? No problem! Download the dedicated PAM-Shell for your OS from the Releases page. It's a ready-to-run executable with the same powerful features.

---

🏁 Quick Start

Using Py-Auto-Migrate is as simple as running one command.

Basic Command Structure

py-auto-migrate migrate --source <SOURCE_URI> --target <TARGET_URI> [--table <TABLE_NAME>]

Argument	Description
--source	Required. Connection URI for the source database.
--target	Required. Connection URI for the target database.
--table	Optional. Migrate a specific table/collection. If omitted, all data is migrated.

Real-World Examples

1. Migrate an entire database from MongoDB to MySQL:

py-auto-migrate migrate \
  --source "mongodb://user:pass@localhost:27017/source_db" \
  --target "mysql://user:pass@localhost:3306/target_db"

2. Migrate a single PostgreSQL table to a new MongoDB collection:

py-auto-migrate migrate \
  --source "postgresql://user:pass@localhost:5432/mydb" \
  --target "mongodb://user:pass@localhost:27017/mydb" \ --table users

✨ The Magic: If the target database or table doesn't exist, Py-Auto-Migrate automatically creates it for you! It intelligently maps source data types to the appropriate target schema.

---

🗄️ Supported Databases

We support a wide and growing range of databases.

Category	Databases
Relational
NoSQL
Other

---

🧭 Future Roadmap

We're constantly working to make Py-Auto-Migrate even better. Here’s what’s on the horizon:

Feature	Status
✅ Click House Support	Completed
⏳ Automatic Index Creation on target tables/collections	In Progress
⏳ Performance Optimizations for terabyte-scale datasets	In Progress
⏳ Incremental Migrations (sync only changes)	Planned
⏳ Graphical User Interface (GUI)	Planned

Have a feature request? Open an issue and let us know!