Sync data from Redshift to SQL Server

by

Want to sync data from Redshift to SQL Server ?

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

Download Withdata DBCopier Download DBCopier

Synchronize data from Redshift to SQL Server

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

Choose source Redshift database and logon.

sync Redshift to SQL Server - Choose Redshift and logon

Choose target SQL Server database and logon.

sync Redshift to SQL Server - Choose SQL Server and logon

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

sync from Redshift to SQL Server - Task Window

then show the wizard.

1. Select source Redshift tables to sync.

sync from Redshift to SQL Server - Open source database

2. List target SQL Server tables.

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

sync data from Redshift to SQL Server - full synchronization

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

sync data from Redshift to SQL Server - upsert synchronization

3. Select SQL Server tables to sync.

sync from Redshift to SQL Server - select tables

4. Sync Redshift data to SQL Server.

sync from Redshift to SQL Server - sync


More about Redshift to SQL Server converter

See also: