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 PostgreSQL and MySQL), 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 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


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

Uploaded Source

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

Hashes for py-auto-migrate-0.0.8.tar.gz
Algorithm Hash digest
SHA256 7784243880a1a955f1f2f347d46635193c3f1612a757111826fd00297df60d5e
MD5 ad2654348ce000bb8ef98a8abd96adeb
BLAKE2b-256 ee431d4a8b4d28c0a6269092895b1f6ca1bfc6005f5aa4bcd6e1c431c7be951a

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