From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

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

Highlighted
Eight Stars

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

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

db.png

 

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 

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog