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.
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/
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 ?
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
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
View this on-demand webinar about APIs....