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.
- Can run in GUI mode, Step by Step, just a few mouse clicks.
- Can run in Command line, for Scheduled Tasks and Streams.
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.
Choose target Redshift database and logon.
Click “Convert All Tables” at task dialog.
then show the wizard.
1. Select source PostgreSQL tables.
2. List target Redshift tables.
3. Select Redshift tables to import.
4. Transfer data from PostgreSQL tables to Redshift.
Batch transfer data from PostgreSQL tables to Redshift in command line
Save “PostgreSQL tables to Redshift” session, then you can:
- Batch transfer PostgreSQL tables to Redshift in Windows command line.
- Batch transfer PostgreSQL tables to Redshift in Linux command line.
- Batch transfer PostgreSQL tables to Redshift in macOS command line.
Set scheduled tasks for coping data from PostgreSQL tables to Redshift
You can schedule and automate this “PostgreSQL to Redshift” conversion task by:
- Save session and create .bat (Windows) or .sh (Linux/macOS) file for “PostgreSQL to Redshift” conversion.
- Set scheduled task for “PostgreSQL to Redshift” conversion.
FAQ
More about Withdata DBCopier – PostgreSQL to Redshift Converter
See also: