Can someone suggest how to migrate a live SQL server database to MySQL Server using Talend? I heard it can be easily done using Talend. I am completely new to Talend so please guide me how to perform this task.
You can easily migrate your database by following the below steps:
In order to perform this job, first, you need to establish the connection with both the databases using the tMSSqlConnection and tMysqlConnection components.
Once you are done, add tMSSqlInput, tMap, and tMysqlOutput components and add them to the workspace.
Connect them as shown below:
In the tMSSqlInput component specify the source table and other necessary details.
Double click the tMap component and select all columns from the left and drag them to the right table.
In the tMysqlOutput component specify the target table along with the other necessary details.
Now, go to the run tab and execute the job.
While working with JSON files, one thing ...READ MORE
As per my knowledge, I think you ...READ MORE
You can try using tNormalize component along ...READ MORE
Well, you can try using following 2 ...READ MORE
Regarding your first issue, tWaitForFile component provides ...READ MORE
I think you should use context variables. ...READ MORE
Its pretty simple you know. All you ...READ MORE
As you might know, in Talend all ...READ MORE
You can do one thing -
1) In ...READ MORE
It is really simple to make tOracleInput ...READ MORE