Sync data from Access to Redshift

by

Posted on by

Want to sync data from Access to Redshift?

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

Download Withdata DBCopier Download DBCopier

Synchronize data from Access to Redshift

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

Choose source Access database and logon.

sync Access to Redshift - Choose Access and logon

Choose target Redshift database and logon.

sync Access to Redshift - Choose Redshift and logon

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

sync from Access to Redshift - Task Window

then show the wizard.

1. Select source Access tables to sync.

sync from Access to Redshift - Open source database

2. List target Redshift tables.

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

sync data from Access to Redshift - full synchronization

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

sync data from Access to Redshift - upsert synchronization

3. Select Redshift tables to sync.

sync from Access to Redshift - select tables

4. Sync Access data to Redshift.

sync from Access to Redshift - sync

More about Access to Redshift converter

See also: