Copy schema from one db connection to another?

One Star

Copy schema from one db connection to another?

HI
Do we have any method by which we can import schema from one metadata db connections to another?
eg. I have a connection - Mysql (as per the demo) and have two schemas in that :customer , state
I have created another connection Oracle :- can i import the schemas customer , state from the MySql connection?
Please advise.
One Star

Re: Copy schema from one db connection to another?

Hi
If you want to import schema automatically, it is impossible.
But you can import and export schema as a xml file manually in TOS.
Right Click on metadata 'Table schemas'-'Edit Schema' and you will find two file icons.
Best regards!
Pedro

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog