Copy MySQL table data to Redshift

by

Posted on by

Want to transfer data from MySQL table to Redshift?

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

Download Withdata DBCopier Download DBCopier

Transfer data from MySQL table To Redshift table

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

Choose source MySQL database and logon.

convert MySQL data to Redshift data - Choose MySQL and logon

Choose target Redshift database and logon.

convert MySQL data to Redshift data - Choose Redshift and logon

Click “Convert From Table” at task dialog.

Import data from MySQL table to Redshift table - Task Window

then show the wizard.

1. Open a source MySQL table.

Convert data from MySQL table to Redshift table - Open Source

2. Select a destination Redshift table and config fields.

Extract MySQL table data to Redshift table - select table

3. Preview data.

Migrage data from MySQL table to Redshift table - preview

4. Import MySQL data to Redshift.

Import data from MySQL table to Redshift table - import

Transfer data from MySQL table to Redshift in command line

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

Set scheduled tasks for transferring data from MySQL table to Redshift

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

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

FAQ

More about Withdata DBCopier – MySQL to Redshift Converter

See also: