search

seanharr11 / etlalchemy

Extract, Transform, Load: Any SQL Database in 4 lines of Code.
MIT License
556 stars 83 forks source link

Close connection whene migration is done. #37

Closed ghost closed 4 years ago

ghost commented 6 years ago

Hey guys!

I'm using this tool inorder to migrate an Oracle db to a MySQL one automaticlly (I'm using crontab by the way) every hour.

I noticed that after a while this causes a blocking at the mysql server due to a large number of connections.

"MySQL Error: Too many connections".

Is there any way to tell the script to close the connection once he's done with migration?

Thanks.

Very cool tool by the way!!