Switch from PostgreSQL to Redshift without programming

by

Posted on by

Want to switch from PostgreSQL to Redshift?

Using Withdata software DB Copier, a PostgreSQL to Redshift converter for Windows, MacOS, and Linux, you can migrate from PostgreSQL to Redshift easily and fast.

  • Step by Step, just a few mouse clicks.
  • Create Redshift tables with auto mapping data types. Create Redshift indexes.

Download DBCopier Download DBCopier

Migrate from PostgreSQL to Redshift

Login to PostgreSQL -> Login to Redshift -> Select tables to migrate -> Migrate from PostgreSQL to Redshift

Choose source PostgreSQL database and logon.

convert PostgreSQL data to Redshift data - Choose PostgreSQL and logon

Choose target Redshift database and logon.

convert PostgreSQL data to Redshift data - Choose Redshift and logon

Click “Wizard – Import All Tables” at task dialog.

migrate from PostgreSQL to Redshift - Task Window

then show the wizard.

1. Open source PostgreSQL .

Switch from PostgreSQL to Redshift - Open source database

2. List target Redshift tables.

Migrate from PostgreSQL to Redshift - list target tables

3. Select Redshift tables to migrate.

Switch from PostgreSQL to Redshift - select tables

4. Migrate from PostgreSQL to Redshift.

Create Redshift tables. Copy PostgreSQL data to Redshift. Create Redshift indexes.

Switch from PostgreSQL to Redshift - migrate

FAQ

More about DBCopier – PostgreSQL to Redshift Converter