I want to migrate the whole db. Can you help me how to achieve that using tMySqlInput and tMySqlOutput? If you database source and database destination have the same structure. You don't really need talend. Just an import/Export with any MySQL client (phpMyadmin, MySQLQueryBrowser, etc.) If you table structure are differents or you you want to transform some data. Talend can do that perfectly. 1) Open new projet 2) Add job 3) Add data base connection source 4) Add data base connection destination 5) Add tMysqlInput (drag and drop table from source table list as input) 6) Add tMysqlOutput (drag and drop table from destination table list as output) 7) Add tMap component 8) Connect all your compenent 9) Verify compenent parameters 10) Execute you job and have fun ;) This video may help you to start.
... View more
Hi and thank you for this real great tool. I have to migrate some contents from MySQL to Ms SQL data base Into my MySQL data base i have only paths of some pictures, i would like to stock the binary of pictures into my MS SQL database. I know that it is possible with TftpfileList or TfileList but have no idea how to convert content and how should i order and arrange those components to do it. If some one can share his experience or help me to do that. (PS : I'm using Talend Open Studio) Thanks !!!
... View more