A Tool For Transferring Data, Tables, And Datasets Between Different Databases.
Project description
𝐏𝐲-𝐀𝐮𝐭𝐨-𝐌𝐢𝐠𝐫𝐚𝐭𝐞
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
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
- SQLite
Future Plans
- Add support for creating indexes on tables/collections to improve query performance.
- Support for more databases: Add migrations for Oracle.
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.1.2.tar.gz.
File metadata
- Download URL: py-auto-migrate-0.1.2.tar.gz
- Upload date:
- Size: 8.8 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/5.1.1 CPython/3.11.4
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
3fa110cd1b330392fc3e1223a320c42296706f3606b3c92fa71d9b44062b0f3f
|
|
| MD5 |
25b92536907fa9ae7972f6362a461bac
|
|
| BLAKE2b-256 |
32628138ab0cc4c6d57e27c1eecf6d07f634cdaf598bcc949f4456aa27d68e4b
|