Transfer data from Redshift table to SQL Server without programming

by

Want to transfer data from Redshift table to SQL Server ?

Using Withdata software DB Copier, a Redshift to SQL Server converter for Windows, MacOS, and Linux, you can transfer data from Redshift table to SQL Server easily and fast.

Download DBCopier Download DBCopier

Transfer data from Redshift table To SQL Server table

Login to Redshift and SQL Server -> Choose source Redshift table -> Set target SQL Server table -> Copy Redshift data to SQL Server

Choose source Redshift database and logon.

convert Redshift  data to SQL Server data - Choose Redshift and logon

Choose target SQL Server database and logon.

convert Redshift  data to SQL Server data - Choose SQL Server and logon

Click “Convert From Table” at task dialog.

Import data from Redshift  table to SQL Server  table - Task Window

then show the wizard.

1. Open a source Redshift table.

Convert data from Redshift  table to SQL Server  table - Open Source

2. Select a destination SQL Server table and config fields.

Extract Redshift  table data to SQL Server  table - select table

3. Preview data.

Migrage data from Redshift  table to SQL Server  table - preview

4. Import Redshift data to SQL Server.

Import data from Redshift  table to SQL Server  table - import

Transfer data from Redshift table to SQL Server in command line

Save “Redshift table to SQL Server” session, then you can:

Set scheduled tasks for transferring data from Redshift table to SQL Server

You can schedule and automate this “Redshift to SQL Server” conversion task by:

1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.

2) Set scheduled task.

FAQ


More about DBCopier Redshift to SQL Server Converter