Migrating Data From Amazon Redshift into Aurora DB

Question

There are tons of examples to migrate data from Aurora DB to Redshift, but I couldn't find any example or documentation for migrating data from Redshift to Aurora DB. Any suggestion/example/doc for migrating data from Redshift into Aurora DB in an efficient way?

Answer 1

You can do it by unloading1 the data into S3 directly from RedShift and then loading it into Aurora2&3.

Redshift UNLOAD Official Docs.

Aurora MySQL LOAD FROM S3 Offical Docs.

Aurora PostgreSQL LOAD FROM S3 Official Docs.

Note that the LOAD on Aurora does not support .parquet or other colunar files, so your best shot is to unload it as .csv. Depending on the size of your tables, you might consider doing it in batches or in periods of reduced workload.

By the moment I'm writting this answer you can't use Redshift as a source for DMS, otherwise this would be the prefered way.