Skip to main content

Migrate data from an Oracle to Postgres

Project description

Oracle to Postgres

The oracle2postgres package can be used to migrate data from Oracle to Postgres. It uses SQLAlchemy as an intermediary to map data types between the two database systems. The approach is hacky, but it worked for us!

Example Notebook

For example usage, see the Jupyter Notebook at: https://github.com/MIT-LCP/oracle-to-postgres/blob/master/migration.ipynb.

Instructions for use

  1. pip install oracle2postgres
  2. Follow the instructions in the Jupyter Notebook at: https://github.com/MIT-LCP/oracle-to-postgres/blob/master/migration.ipynb.

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

oracle2postgres-0.1.5.tar.gz (8.2 kB view details)

Uploaded Source

Built Distribution

oracle2postgres-0.1.5-py2.py3-none-any.whl (8.3 kB view details)

Uploaded Python 2Python 3

File details

Details for the file oracle2postgres-0.1.5.tar.gz.

File metadata

  • Download URL: oracle2postgres-0.1.5.tar.gz
  • Upload date:
  • Size: 8.2 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.18.4 setuptools/40.7.1 requests-toolbelt/0.8.0 tqdm/4.23.0 CPython/3.6.5

File hashes

Hashes for oracle2postgres-0.1.5.tar.gz
Algorithm Hash digest
SHA256 c26034eeaa5ec9a2d58d77d15cd7c2e70220a4484c5e3372de8a795bb37b8bda
MD5 0a951b75f0c38a772d09d316361263ce
BLAKE2b-256 87c75f2270378a0a6a1ce89d6080f66f348206a5a75537f2e1ab929ab56b8dc1

See more details on using hashes here.

File details

Details for the file oracle2postgres-0.1.5-py2.py3-none-any.whl.

File metadata

  • Download URL: oracle2postgres-0.1.5-py2.py3-none-any.whl
  • Upload date:
  • Size: 8.3 kB
  • Tags: Python 2, Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.18.4 setuptools/40.7.1 requests-toolbelt/0.8.0 tqdm/4.23.0 CPython/3.6.5

File hashes

Hashes for oracle2postgres-0.1.5-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 00e5259da015142262eb082208018401d88fda1d8e439ed129e944ae8a678ac1
MD5 ded85aff8fd7722784f4467ed323e357
BLAKE2b-256 8501898787bdf8ce3e9feb4ef353c55569cfa3a82b2b0616fb2ef4a2da91a101

See more details on using hashes here.

Supported by

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