Skip to main content

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.

GitHub


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


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

py-auto-migrate-0.1.2.tar.gz (8.8 kB view details)

Uploaded Source

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

Hashes for py-auto-migrate-0.1.2.tar.gz
Algorithm Hash digest
SHA256 3fa110cd1b330392fc3e1223a320c42296706f3606b3c92fa71d9b44062b0f3f
MD5 25b92536907fa9ae7972f6362a461bac
BLAKE2b-256 32628138ab0cc4c6d57e27c1eecf6d07f634cdaf598bcc949f4456aa27d68e4b

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page