Transfer data from DB2 table to Redshift without programming

by

Want to transfer data from DB2 table to Redshift?

Using Withdata software DB Copier, a DB2 to Redshift converter for Windows, MacOS, and Linux, you can transfer data from DB2 table to Redshift easily and fast.

Download DBCopier Download DBCopier

Transfer data from DB2 table To Redshift table

Login to DB2 and Redshift -> Choose source DB2 table -> Set target Redshift table -> Copy DB2 data to Redshift

Choose source DB2 database and logon.

convert DB2  data to Redshift data - Choose DB2 and logon

Choose target Redshift database and logon.

convert DB2  data to Redshift data - Choose Redshift and logon

Click “Convert From Table” at task dialog.

Import data from DB2  table to Redshift  table - Task Window

then show the wizard.

1. Open a source DB2 table.

Convert data from DB2  table to Redshift  table - Open Source

2. Select a destination Redshift table and config fields.

Extract DB2  table data to Redshift  table - select table

3. Preview data.

Migrage data from DB2  table to Redshift  table - preview

4. Import DB2 data to Redshift.

Import data from DB2  table to Redshift  table - import

Transfer data from DB2 table to Redshift in command line

Save “DB2 table to Redshift” session, then you can:

Set scheduled tasks for transferring data from DB2 table to Redshift

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

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

2) Set scheduled task.

FAQ


More about DBCopier DB2 to Redshift Converter