How can I use Data Pipeline to copy tables from one database table to another?

Copy an Amazon RDS MySQL table to Amazon Redshift

Create a pipeline using one of the following Data Pipeline templates:

• Full Copy of Amazon RDS MySQL Table to Amazon Redshift

• Incremental Copy of an Amazon RDS MySQL Table to Amazon Redshift

For more information about these templates, see Amazon RDS to Amazon Redshift Templates.

Copy an Amazon RDS PostgreSQL table to an Amazon Redshift table

Use the PostgresqlRdsToRedshift scripts from the AWSLabs GitHub repository. Before you begin, modify the postgresqlRDS-to-Redshift-definition.json file with the following:

• Your database
• Your Amazon Elastic Compute Cloud (Amazon EC2) instance
• The path to your hosted shell script in Amazon Simple Storage Service (Amazon S3)

Copy an Amazon RDS MySQL table to an Amazon RDS PostgreSQL table

Use the MySqlRdsToPostgreSqlRds scripts from the AWSLabs GitHub repository. Before you begin, modify the mysqlRDS-psqlRDS-copy-using-shell-definition.json file with the following:

• Your database
• Your EC2 instance
• The path to your hosted shell script in Amazon S3