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

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

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