If you're running Windows 10 then you might be able to use etlalchemy under WSL. If you're running Windows 8.1 then VirtualBox + your_Linux_distro_of_choice + etlalchemy would be another option.
The etlalchemy repo <https://github.com/seanharr11/etlalchemy> shows that the project is 100% Python so it *should* be possible to get it running natively on Windows. I suspect that the original author just didn't bother. Note: I have no experience with etlalchemy, it just seems a shame for you to re-invent the wheel when it is just what you are looking for. On Saturday, February 1, 2020 at 1:58:06 PM UTC-7, Alex Hill wrote: > > Hello everyone, > > I apologize if this question has been answered before, i've done some of > my of searching and solution testing before coming here. > > I've even created a thread on stackoverflow > https://stackoverflow.com/questions/60008289/copy-or-migrate-tables-from-mysql-database-to-oracle-11g-and-vice-versa-using-py > > I am using Python 3.6 & sqlalchemy 1.3.13, mysql workbench 8.0 and sql > developer vers.19 > > Just like the title I would like to copy all the tables and their > properties from MySQL to Oracle. You can see the solutions I have used in > the link above after edit 1. > Up till now none of them worked except pandas read_mysql and to_sql but is > it the right way to do it, does it really copy everything? is there anyway > to "automate" the process without having to specify the table I want to > copy? > > I wanted to use etlalchemy which builds upon sqlalchemy but it's not > available for windows (which i'm using) > > Thank you for your help, this project is related to school. > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/1104b862-f6d5-427c-aecd-64c17e923447%40googlegroups.com.
