Migrate Entire Databases Using Alteryx

[Atabarezz]

So it takes while to download data from in-db (say oracle table) and load it to another...

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-To-Migrate-Entire-Databases-Using-Altery...

Why not build an additional in-db tool to migrate data without downloading to local...

Oracle has this capability and here is the Syntax;

COPY Command Syntax

COPY {FROM database | TO database | FROM database TO database} {APPEND|CREATE|INSERT|REPLACE} destination_table [(column, column, column, ...)]
USING query

where database has the following syntax:

username[/password]@connect_identifier

Copies data from a query to a table in a local or remote database. COPY supports the following datatypes:

CHAR DATE LONG NUMBER VARCHAR2

Example;

COPY FROM HR/your_password@BOSTONDB -
TO TODD/your_password@CHICAGODB -
CREATE NEWDEPT (DEPARTMENT_ID, DEPARTMENT_NAME, CITY) -
USING SELECT * FROM EMP_DETAILS_VIEW

[Atabarezz]

it takes a very long distance and bears a lot of bandwidth bottleneck to migrate data from one DB to another...

[Atabarezz]

Proposing something like this

[r4upadhye]

much needed feature

[mestevez1]

This would be a killer feature. I'm surprised it didn't take the traction it deserves.