[sqlalchemy] Re: Correct and easy method to copy tables from MySQL to Oracle

[Gord Thompson]

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  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 sqlalchemy+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sqlalchemy/1104b862-f6d5-427c-aecd-64c17e923447%40googlegroups.com.

[sqlalchemy] Correct and easy method to copy tables from MySQL to Oracle

[Alex Hill]

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.