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

Uploaded Source

Built Distribution

oracle2postgres-0.1.1-py2.py3-none-any.whl (7.7 kB view details)

Uploaded Python 2Python 3

File details

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

File metadata

  • Download URL: oracle2postgres-0.1.1.tar.gz
  • Upload date:
  • Size: 7.5 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.1.tar.gz
Algorithm Hash digest
SHA256 7bc2951deae18ec3971dae7c7032da96aabe413692280a2590d8811ca52d28db
MD5 cc1d7a9a9eac2f283107abd7e742fa82
BLAKE2b-256 19d3949f3c5de599b717513ea72d076c8c6313c3b4867c8ea5c321e4bd6efa64

See more details on using hashes here.

File details

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

File metadata

  • Download URL: oracle2postgres-0.1.1-py2.py3-none-any.whl
  • Upload date:
  • Size: 7.7 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.1-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 3f75557b22e3b24805acccb57143ca870a0fc509731c626f33b8056250302a31
MD5 4d7603bab722a7cf7e4ccfbec28bda24
BLAKE2b-256 920c943bd8a5d9e7ae7cc57bc53bb1f1456d35a1ced09de1f050871a99019b36

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