Batch copy PostgreSQL tables to Redshift

by

Want to batch copy data from PostgreSQL tables to Redshift?

Try Withdata DBCopier, a PostgreSQL to Redshift converter for Windows, Mac, and Linux, Bulk copy PostgreSQL to Redshift, Easy and Fast.

Download Withdata DBCopier Download DBCopier

Batch copy data from PostgreSQL tables to Redshift tables

Login to PostgreSQL and Redshift -> Select source PostgreSQL tables -> Set target Redshift tables -> Copy PostgreSQL data to Redshift

Choose source PostgreSQL database and logon.

convert PostgreSQL data to Redshift data - Choose PostgreSQL and logon

Choose target Redshift database and logon.

convert PostgreSQL data to Redshift data - Choose Redshift and logon

Click “Convert All Tables” at task dialog.

Batch import data from PostgreSQL tables to Redshift tables - Task Window

then show the wizard.

1. Select source PostgreSQL tables.

Batch convert data from PostgreSQL tables to Redshift tables - Open Source schema

2. List target Redshift tables.

Batch extract data from PostgreSQL tables to Redshift tables - select destination schema

3. Select Redshift tables to import.

Batch import data from PostgreSQL tables to Redshift tables - select tables

4. Transfer data from PostgreSQL tables to Redshift.

Batch copy data from PostgreSQL tables to Redshift tables - batch import

Batch transfer data from PostgreSQL tables to Redshift in command line

Save “PostgreSQL tables to Redshift” session, then you can:

Set scheduled tasks for coping data from PostgreSQL tables to Redshift

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

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “PostgreSQL to Redshift” conversion.
  2. Set scheduled task for “PostgreSQL to Redshift” conversion.

FAQ


More about Withdata DBCopier PostgreSQL to Redshift Converter

See also: