Geek asks and answers

Moving a Quickstart Database Using Talend

I have this requirement to port live SQL server 2008to MySQL server 5, I tried the MySQL migration toolkit, but it threw a lot of migration errors. Someone here at Stackoverflow suggested using Talend. I installed Talend Open Studio for Data Integration, but it is a fairly universal tool in which there is no quick start of database migration, like what I really need.

Where can I find a quick start guide to use Talend for this kind of work?

+5
source share
4 answers

If you need to get started with Talend, I can suggest you check out our documentation page http://www.talend.com/resources/documentation.php where you can find installation guides and user guides.

In addition, there is an interesting section on our website where you can familiarize yourself with our tutorials that should help: http://www.talendforge.org/tutorials/menu.php

0
source

Talend is a pretty general data integration tool, but you have to do this work by following these steps (which really apply to any type of database: PostgreSQL, Oracle, etc.):

  • , - " Db" - node. " DB" "Microsoft SQL Server" ( - ) .
  • , "MySQL" ( - - ).
  • " " ( ).
  • "SQL Server" -DB- ( " " ) tMSSqlInput.
  • MySQL-DB- tMysqlOutput. .
  • "" tMap .
  • tMSSqlInput tMap tMap tMysqlOutput . , tMSSqlInput, Row-Main tMap. tMap tMysqlOutput.
  • tMap, . tMap . , tMap . .
  • . - , Talend Studio , .
+11

xybrek, , , .

, , Talend.

The components that you will look at: tMssqlInput - reads a table in the MsSQL database tMySQLOutput - directs the data stream, for example, the output of the mssqlinput component, to the mysql table tMySQLRow - allows you to execute a query in the mysql table / database

And maybe others. These are just some of the more obvious components.

You can find more information about them in the reference manual that covers all the components in Talend.

Good luck

0
source

More articles:


All Articles