Hi,
I just recently started using Talend Data Integration and I'm figuring out how I could migration mssql server databases to mysql databases.
So far what I have found in the discussion community the way to migrate by table with the condition that the output table should exist with columns already setted.
What I wanted to do here to to use mssql server database to generate mysql database from scratch (no schemas, tables created prior).
This is what I've been doing so far
tablelist, columnlist = tablename is not specific, because I wanted all tables in the database
fixedflowinput = I had to choose one table (though I wanted all tables as mentioned above)
logrow = build-in input
this is still midway, because I still couldn't figure out which components or setting I should put to make it work.
what i'm trying to achieve
MSSQL SERVER DB (existing data) => create new mysql DB using mssql server data
Please let me know if you need anymore information.
I'm very confuse as there are no clear documentation on whole database migration,
please be lenient with me.
Thank you