migrate from mssql server to mysql (whole database, not by table)

Anonymous — Wed, 26 Feb 2020 10:30:32 GMT

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

topic migrate from mssql server to mysql (whole database, not by table) in Talend Studio

migrate from mssql server to mysql (whole database, not by table)