Sync data from SQL Server to Redshift

by

Want to sync data from SQL Server to Redshift?

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

Download Withdata DBCopier Download DBCopier

Synchronize data from SQL Server to Redshift

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

Choose source SQL Server database and logon.

sync SQL Server to Redshift - Choose SQL Server and logon

Choose target Redshift database and logon.

sync SQL Server to Redshift - Choose Redshift and logon

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

sync from SQL Server to Redshift - Task Window

then show the wizard.

1. Select source SQL Server tables to sync.

sync from SQL Server to Redshift - Open source database

2. List target Redshift tables.

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

sync data from SQL Server to Redshift - full synchronization

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

sync data from SQL Server to Redshift - upsert synchronization

3. Select Redshift tables to sync.

sync from SQL Server to Redshift - select tables

4. Sync SQL Server data to Redshift.

sync from SQL Server to Redshift - sync


More about SQL Server to Redshift converter

See also: