data-transfer-mysql

MySQL Data Transfer Example

Example project using mysql with pyodbc docker image.

Running

Create a .env file using the example file.

$ cp .env.example .env

Run the example.

$ docker-compose up

Output

The output of the application should look like this.

app_1           | Establishing mysql database connection to mysql-db1.
app_1           | Establishing mysql database connection to mysql-db2.
app_1           | Create users table and populate data in source database.
app_1           | Create users table in destination database.
app_1           | Extracting users data from source database.
app_1           | Transferring users data to destination database.
app_1           | Transferred 3 rows of users data from source database to destination database.
app_1           | Display users data in destination database.
app_1           | ID    NAME            CITY
app_1           | --------------------------------
app_1           | 1     Laura Levy       Evanberg
app_1           | 2     Justin James     Caseyport
app_1           | 3     Peggy Joseph     Baker haven