Migration from one database to another

Four Stars PTN
Four Stars

Migration from one database to another


I'm trying to develop a job that allows me to migrate all tables from one database (oracle or mysql) to another database (postgresql).

I had already realized this processing to switch the tables from a database to files, but I lost my processing and can no longer develop it again. I had used the dynamic schema function.

This time I try with a tOracleTableList then tIterateToFlow then tOracleInput then tPostgresql but I'm currently getting this error : "Error in the component's properties:The type of the expression must be an array type but it resolved to String
Syntax error on token "tOracleTableList_1_CURRENT_TABLE", [ expected
Type mismatch: cannot convert from String to int
Syntax error, insert "]" to complete Expression".

I can not manage the dynamic schema. I may have set up a component incorrectly.


Someone would have already developed this treatment ?

I did not find the answer in another conversation.



Forteen Stars

Re: Migration from one database to another

just a personal vision

the task could be interesting as educational or research, but Talend definitely - NOT a universal database migration tool


Yes, it great for ETL, it could be used for transfer a few tables

but a lot of tools dedicated for migration from specific database to other specific database


it could be packages like MS SQL Server migration assistance 

or 3rd parties like - http://www.sqlmaestro.com/products/postgresql/converter/


or http://ora2pg.darold.net/news.html



Four Stars PTN
Four Stars

Re: Migration from one database to another

thank you for your reply.

But I'm looking for a free tool to migrate a mysql database into postgresql and since we own Talend, I want to use it for my need because Talend knows how to handle this kind of problem.

Unless there is a free tool for my need ?

Forteen Stars

Re: Migration from one database to another

I special include for You 2nd link - it open source, from GitHub ;-)


Talend - NOT a tool for automatic migration


it good when You need map and transform, but it mean work with each source and target object individually

about free/not free - when I have a problem, I look for cost of solution ... and if it less than cost of my time - I just buy it (even for single time project). Time is also money

Four Stars PTN
Four Stars

Re: Migration from one database to another

Thank you I will look at the links.

My wish was to succeed in setting Talend's dynamic schema, if someone has leads.

Thank you


Talend named a Leader.

Get your copy


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 4

Pick up some tips and tricks with Context Variables


How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration


APIs for Dummies

View this on-demand webinar about APIs....

Watch Now