I have searched over the internet but did not get the right answer.
How to migrate data from one data base to other in talend open studio.
Example...i want to migrate tables from MS SQL SERVER to ORACLE.(I know we can do it with dynamic schema column support in enterprise version, but how to do in open studio)
With Talend open studio, you have to create different subjobs to map each table, you need to define the schema manually for each table' structure, it is indeed a lot of work for you to do if you have many tables. I suggest you find out if there are any special database tools that can help you complete the migration.
