seanharr11/etlalchemy
View on GitHub ↗ ★ 557 Python
Extract, Transform, Load: Any SQL Database in 4 lines of Code.
7 mentions on Hacker News by 1 person: 2 stories, 5 comments · first 2016-08-29 · latest 2018-11-14
20082026
-
…scalability. I need 3 more. Probably will be looking for some help if anyone's interested... https://www.github.com/seanharr11/etlalchemy
comment by seanharr11 · 2018-11-14 · in Best practices for migrating an Oracle database to Amazon PostgreSQL -
…I migrated off of Oracle and onto MySQL, but the tool supports any RDBMS supported by SQLAlchemy. https://github.com/seanharr11/etlalchemy The best way to know is to try! It takes 4 lines of python to get you migrated. PostgreSQL is a bit…
comment by seanharr11 · 2017-08-24 · in Ask HN: Have You Ever Migrated from MySQL to PostgresQL or Otherwise? -
I wrote an open source tool that migrates between any 2 relational databases. https://github.com/seanharr11/etlalchemy This includes automatic migration of the schema, constraints, indexes and obviously data. It leverages fast bulk loading…
comment by seanharr11 · 2017-08-16 · in Migrating 1200 databases from MySQL to Postgres -
…be solved with this tool, including schema/index migrations, and even initial (fast) data transfer: https://github.com/seanharr11/etlalchemy
comment by seanharr11 · 2017-08-16 · in Migrating 1200 databases from MySQL to Postgres -
…foreign key that is violated during the "constraint migration" step. 4. Regarding tools, we used https://github.com/seanharr11/etlalchemy to facilitate the migration. I created this open source tool 2 years ago, published it to github, and…
comment by seanharr11 · 2016-08-30 · in Ask HN: Do you have a Oracle to PostgreSQL migration success story?