topic Re: replication of more than one MySQL database table in Talend Studio

replication of more than one MySQL database table

Anonymous — Sat, 16 Nov 2024 13:19:15 GMT

Hi,
Is it possible with Talend Open Studio (TOS) to make with one job the replication of more than one MySQL database table or we should make a job for each table replication. In fact, I want to schedule the execution of the replication of all tables in the same time, that's why I'm trying to make all the replications in one job.
If this is not possible, and if I must make a job for each table replication, how can I schedule all these jobs to be executed in the same time (every day)? I'm using windows scheduler.
Best Regards,
Nizar.

Re: replication of more than one MySQL database table

Anonymous — Mon, 09 Aug 2010 18:48:55 GMT

hi Nizar,
I think that schedule some mysqlDump with windows scheduler is not a "bad way" if you're running with TOS.
Have you got some special reasons to do that through Talend's job
Have a look on this post
regards
laurent

Re: replication of more than one MySQL database table

Anonymous — Mon, 09 Aug 2010 19:25:45 GMT

I understood what you mean, but if I use windows scheduler, I will be obliged to make a task for each database table replication, which is too long to perform if we have databases with 100 tables for examples. Thus, my question is: is there a way to use only one job to make the replication of all tables?
regards,
Merci Laurent
Nizar.

Re: replication of more than one MySQL database table

_AnonymousUser — Thu, 06 Oct 2011 18:23:28 GMT

Couldn't you write a batch file that spawns the 100+/- jobs, and then schedule that one batch file?
Cheers,
Dave