community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Migrate Entire Databases Using Alteryx

 

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
2 Comments
Alteryx Partner

Picture1.png

 

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

Alteryx Partner

Proposing something like this

 

 

Picture2.png