Skip to main content

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 MongoDB and MongoDB), with automatic table/database creation, existence checks, and support for full database migrations.

GitHub


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 MySQL → MySQL


Future Plans

  • Add support for creating indexes on tables/collections to improve query performance.
  • Support for more databases: Add migrations for PostgreSQL, SQLite.

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.0.3.tar.gz (4.1 kB view details)

Uploaded Source

File details

Details for the file py-auto-migrate-0.0.3.tar.gz.

File metadata

  • Download URL: py-auto-migrate-0.0.3.tar.gz
  • Upload date:
  • Size: 4.1 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.0.3.tar.gz
Algorithm Hash digest
SHA256 50c4cc979c22514b18503ad2316b69c3b5baa8b43f5dfbbb03b7836f1588fac5
MD5 a93c1f027f170a82eed49140a90f23ac
BLAKE2b-256 2a938b28c50f079a72f344a8eafa305bd32c0a3e28b44936046aad3969deb82f

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