Database Migration In Talend

0 votes

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.

Apr 18, 2018 in Talend by misc.edu04
• 1,380 points
48 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

You can easily migrate your database by following the below steps:

  1. In order to perform this job, first, you need to establish the connection with both the databases using the tMSSqlConnection and tMysqlConnection components.

  2. Once you are done, add tMSSqlInput, tMap, and tMysqlOutput components and add them to the workspace.

  3. Connect them as shown below:image

  4. In the tMSSqlInput component specify the source table and other necessary details.

  5. Double click the tMap component and select all columns from the left and drag them to the right table.

  6. In the tMysqlOutput component specify the target table along with the other necessary details.

  7. Now, go to the run tab and execute the job.

answered Apr 18, 2018 by code.reaper12
• 3,450 points

Related Questions In Talend

0 votes
1 answer

Parsing JSON in Talend

While working with JSON files, one thing ...READ MORE

answered Apr 2, 2018 in Talend by code.reaper12
• 3,450 points
324 views
0 votes
1 answer
0 votes
1 answer

Converting Columns into Rows in Talend

Hi, You can try using tNormalize component along ...READ MORE

answered Apr 10, 2018 in Talend by code.reaper12
• 3,450 points

edited Apr 10, 2018 by code.reaper12 377 views
0 votes
1 answer

Implement Common Logging in Talend

Well, you can try using following 2 ...READ MORE

answered Apr 11, 2018 in Talend by geek.erkami
• 2,320 points
59 views
0 votes
1 answer

tWaitForFile component insufficiency in Talend

Regarding your first issue, tWaitForFile component provides ...READ MORE

answered Apr 10, 2018 in Talend by geek.erkami
• 2,320 points
163 views
0 votes
1 answer

Parameterizing a tOracleInput component using Talend

I think you should use context variables. ...READ MORE

answered Apr 18, 2018 in Talend by geek.erkami
• 2,320 points
107 views
0 votes
1 answer
0 votes
1 answer

Closed loop in Talend

As you might know,  in Talend all ...READ MORE

answered Apr 19, 2018 in Talend by code.reaper12
• 3,450 points
214 views
0 votes
1 answer

Assigning a database value to a context variable in Talend

You can try following the below steps: 1. Select ...READ MORE

answered Apr 4, 2018 in Talend by code.reaper12
• 3,450 points
210 views
0 votes
1 answer

Looping through all the schemas in Talend

It is really simple to make tOracleInput ...READ MORE

answered Apr 10, 2018 in Talend by code.reaper12
• 3,450 points
46 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.