Transfer data from multiple similar Oracle tables to same Redshift table without programming

Want to transfer data from multiple similar Oracle tables to 1 Redshift table?

Using DBCopier, a native GUI tool, you can transfer data from multiple similar Oracle tables to single Redshift table easily and fast, just a few mouse clicks.

Support Windows, Linux, macOS

Here you can download and install DBCopier.

Transfer data from multiple similar Oracle tables To same Redshift table

Choose source Oracle database and logon.

Choose target Redshift database and logon.

Click “Convert Similar Tables” at task dialog.

then show the wizard.

1. Select similar tables.

2. Select a destination table and config fields.

3. Preview data.

4. Import.

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task.

---

More about DBCopier – the tool to copy Oracle data to Redshift