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:![image](https://lh3.googleusercontent.com/AygKyJ08Hcudj5Da4KE9-lbeo1aEc7PVVmKyE0nX4Vie57a-zP4ReaCl_1YofvnkK5Tg-uA8bWWV4nTugsh_rN6DRCMqDW4d3-3YKBZ1xpkcIvG1WjmhqEumIgM3HmdmuT9a2_vD)
-
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.
Hope this was what you were looking for.
Get your Talend certification today to become certified professional.
Thanks.