Sync data from DB2 to Redshift

by

Want to sync data from DB2 to Redshift?

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

Download Withdata DBCopier Download DBCopier

Synchronize data from DB2 to Redshift

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

Choose source DB2 database and logon.

sync DB2 to Redshift - Choose DB2 and logon

Choose target Redshift database and logon.

sync DB2 to Redshift - Choose Redshift and logon

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

sync from DB2 to Redshift - Task Window

then show the wizard.

1. Select source DB2 tables to sync.

sync from DB2 to Redshift - Open source database

2. List target Redshift tables.

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

sync data from DB2 to Redshift - full synchronization

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

sync data from DB2 to Redshift - upsert synchronization

3. Select Redshift tables to sync.

sync from DB2 to Redshift - select tables

4. Sync DB2 data to Redshift.

sync from DB2 to Redshift - sync


More about DB2 to Redshift converter

See also: