A Tool For Transferring Data, Tables, And Datasets Between Different Databases.
Project description
Py-Auto-Migrate
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
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
Future Plans
- Add support for creating indexes on tables/collections to improve query performance.
- Support for more databases: Add migrations for SQLite.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
File details
Details for the file py-auto-migrate-0.0.8.tar.gz.
File metadata
- Download URL: py-auto-migrate-0.0.8.tar.gz
- Upload date:
- Size: 7.2 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/5.1.1 CPython/3.11.4
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
7784243880a1a955f1f2f347d46635193c3f1612a757111826fd00297df60d5e
|
|
| MD5 |
ad2654348ce000bb8ef98a8abd96adeb
|
|
| BLAKE2b-256 |
ee431d4a8b4d28c0a6269092895b1f6ca1bfc6005f5aa4bcd6e1c431c7be951a
|