Transfer data from MySQL query to PostgreSQL table without programming

by

Posted on by

Want to transfer data from MySQL query results to PostgreSQL table?

Using Withdata software DB Copier, a MySQL to PostgreSQL converter for Windows, MacOS, and Linux, you can transfer data from MySQL (MariaDB, Percona) query result to PostgreSQL table easily and fast.

Download DBCopier Download DBCopier

Transfer data from MySQL (MariaDB, Percona) query To PostgreSQL table

Login to MySQL and PostgreSQL -> Enter source MySQL query -> Set target PostgreSQL table -> Copy MySQL query data to PostgreSQL table

Choose source MySQL database and logon.

convert MySQL (MariaDB, Percona) query to PostgreSQL table - Choose MySQL and logon

Choose target PostgreSQL database and logon.

save MySQL (MariaDB, Percona) query results to PostgreSQL table - Choose PostgreSQL and logon

Click “Convert From Query” at task dialog.

Import data from MySQL (MariaDB, Percona) query results to PostgreSQL table - Task Window

then show the wizard.

1. Set a MySQL query.

Convert data from MySQL (MariaDB, Percona) query results to PostgreSQL table - open query results

2. Select a destination PostgreSQL table and config fields.

Extract MySQL (MariaDB, Percona) query results data to PostgreSQL table - select table

3. Preview data.

Migrage data from MySQL (MariaDB, Percona) query results to PostgreSQL table - preview

4. Transfer data from MySQL (MariaDB, Percona) query result to PostgreSQL table.

save data from MySQL (MariaDB, Percona) query results to PostgreSQL table - import

Transfer data from MySQL query to PostgreSQL in command line

Save “MySQL query to PostgreSQL” session, then you can:

Set scheduled tasks for transferring data from MySQL query to PostgreSQL

You can schedule and automate this “MySQL to PostgreSQL” conversion task by:

1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.

2) Set scheduled task.

FAQ

More about DBCopier – MySQL to PostgreSQL Converter