Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

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
5 Comments
Atabarezz
13 - Pulsar

Picture1.png

 

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

Atabarezz
13 - Pulsar

Proposing something like this

 

 

Picture2.png

 

r4upadhye
11 - Bolide

much needed feature

mestevez1
8 - Asteroid

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

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes