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 sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/7dcc0874-9e52-4231-a0b5-55539ee111fb%40googlegroups.com.