Apr-24-2020, 08:04 AM
Hi Python developers,
I'm a beginner in the Python programming environment, I started doing online Python courses and I would like to use Python in the data analysis area.
Therefore, I would like to ask you if there is anyone among you who has done a massive (1: 1) data transfer from MySql to Sql Server, using Python.
I would like to know if this can be done using Python. In this way, I could remove the ETL tool which has limitations when it comes to large data transfers from two different DBMS systems.
Therefore, I would like to know if I can do the following steps in Python:
Step 1. Connect to the Mysql database.
Step 2. Access to the table where I want to get my data.
something like "select * from table"
Step 3. Copy the data to the new table on the Sql Server.
I want to make a simple copy (1: 1) without transformations or data aggregation, etc.
I found some information about Python data frames (Pandas or Dask) but the examples used files for manipulating data and inserting them into a database.
In my case, should I use Python SQL Driver - pyodbc?
Are there other Python drivers that are better at extracting data from databases?
Thanks,
Adrian
I'm a beginner in the Python programming environment, I started doing online Python courses and I would like to use Python in the data analysis area.
Therefore, I would like to ask you if there is anyone among you who has done a massive (1: 1) data transfer from MySql to Sql Server, using Python.
I would like to know if this can be done using Python. In this way, I could remove the ETL tool which has limitations when it comes to large data transfers from two different DBMS systems.
Therefore, I would like to know if I can do the following steps in Python:
Step 1. Connect to the Mysql database.
Step 2. Access to the table where I want to get my data.
something like "select * from table"
Step 3. Copy the data to the new table on the Sql Server.
I want to make a simple copy (1: 1) without transformations or data aggregation, etc.
I found some information about Python data frames (Pandas or Dask) but the examples used files for manipulating data and inserting them into a database.
In my case, should I use Python SQL Driver - pyodbc?
Are there other Python drivers that are better at extracting data from databases?
Thanks,
Adrian