Do I have to create and run 28 jobs inorder to extract 28 databases from MSSQL Server2000?


I have to extract 28 tables from MS SQL Server 2000 using jaspersoft etl, transfrom them and load them onto a Mysql database. The question is:

Does this mean creating 28 jobs? This I know how to do.

Or can I extract them in one job? If so how?


Post Edited by rumbi at 02/07/2012 17:32

Post Edited by rumbi at 02/07/2012 17:35

Post Edited by rumbi at 02/07/2012 17:35
rumbi's picture
Joined: Jan 24 2012 - 2:03am
Last seen: 11 years 8 months ago

1 Answer:

Hi Rumbi

What kind of transformation you need to perform? of course you can do everything (probably) in just 1 job, but this can raise problems in performances, memory and so on.
If it's just a migration (copy 1 table into another in another dbms) it's easy and you can do as you prefer, but if you need to join tables you need a better design.

agharti81's picture
Joined: Feb 7 2012 - 3:40am
Last seen: 7 years 8 months ago