Copy SQL Server table data to Redshift

by

Posted on by

Want to transfer data from SQL Server table to Redshift?

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

Download Withdata DBCopier Download DBCopier

Transfer data from SQL Server table To Redshift table

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

Choose source SQL Server database and logon.

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

Choose target Redshift database and logon.

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

Click “Convert From Table” at task dialog.

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

then show the wizard.

1. Open a source SQL Server table.

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

2. Select a destination Redshift table and config fields.

Extract SQL Server table data to Redshift table - select table

3. Preview data.

Migrage data from SQL Server table to Redshift table - preview

4. Import SQL Server data to Redshift.

Import data from SQL Server table to Redshift table - import

Transfer data from SQL Server table to Redshift in command line

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

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

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

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “SQL Server to Redshift” conversion.
  2. Set scheduled task for “SQL Server to Redshift” conversion.

FAQ

More about Withdata DBCopier – SQL Server to Redshift Converter

See also: