Sync data from Redshift to DB2

by

Want to sync data from Redshift to DB2 ?

Try Withdata DBCopier, a Redshift to DB2 converter for Windows, Mac, and Linux, Synchronize Redshift to DB2, Easy and Fast.

Download Withdata DBCopier Download DBCopier

Synchronize data from Redshift to DB2

Login to Redshift and target DB2 -> Select source Redshift tables -> Set target DB2 tables -> Sync Redshift data to DB2

Choose source Redshift database and logon.

sync Redshift to DB2 - Choose Redshift and logon

Choose target DB2 database and logon.

sync Redshift to DB2 - Choose DB2 and logon

Click “Wizard – Import All Tables” at task dialog.

sync from Redshift to DB2 - Task Window

then show the wizard.

1. Select source Redshift tables to sync.

sync from Redshift to DB2 - Open source database

2. List target DB2 tables.

Set “Import Type” to “Replace”, it will do a full synchronization.

sync data from Redshift to DB2 - full synchronization

Or set “Import Type” to “Upsert”, it will do a upsert synchronization.

sync data from Redshift to DB2 - upsert synchronization

3. Select DB2 tables to sync.

sync from Redshift to DB2 - select tables

4. Sync Redshift data to DB2.

sync from Redshift to DB2 - sync


More about Redshift to DB2 converter

See also: