topic Re: Copy table from one server to another in Talend Studio

Copy table from one server to another

Anonymous — Wed, 17 Sep 2014 10:41:21 GMT

Hi everyone,
Does anyone know what would be the easiest or "normal" way to copy a table from one server to another using Talend? I mean, which components would normally be best suited for this job?
I already have the table created in my target database, so I only need to transfer the data in the source table.
Thanks!
Cihan

Re: Copy table from one server to another

Anonymous — Wed, 17 Sep 2014 10:54:43 GMT

Would, for example, a simple job like this do it?
When I run it, I get a "Exception in component tMSSqlOutput_1 java.sql.SQLException: Network error IOException: Connection refused: connect" error message, but I guess that's beside the point.

Re: Copy table from one server to another

Anonymous — Wed, 17 Sep 2014 10:55:46 GMT

Hi Cihan
- Create metadata for first server
- Create metadata for second server
- use following flow
tDBInput(server1)-->tDBOutput(server2)
Above is sample scenario...
Vaibhav

Re: Copy table from one server to another

Anonymous — Wed, 17 Sep 2014 11:04:14 GMT

Hi,
DB input-->DB Output is a "normal" way to copy a table from one server to another.
For your error, Network error IOException: Connection refused: connect" error message.Your DB connection paramater is not correct. please check it.
Best regards
Sabrina

Re: Copy table from one server to another

Anonymous — Wed, 17 Sep 2014 11:05:39 GMT

OK, regarding my own job: I have corrected the connection, and everything works, but no rows are actually inserted into the target table. It is simply blank.
Regarding Vaibhav's solution: I'll do it in a minute and let you know how it went.
Thanks!

Re: Copy table from one server to another

Anonymous — Wed, 17 Sep 2014 11:06:14 GMT

Test if the target output component has set the option Die on error.

Re: Copy table from one server to another

Anonymous — Wed, 17 Sep 2014 11:15:02 GMT

The documentation here https://help.talend.com/search/all?query=tDBInput&content-lang=en says that I need to fill in the database name of the tDBInput component, whereas in my Talend the field is called "datasource".
What exactly is the difference between them? What am I supposed to put in that field?

Re: Copy table from one server to another

Anonymous — Wed, 17 Sep 2014 11:26:35 GMT

Hi cihanc83,
What's your DB? Not Mssql server?
Best regards
Sabrina

Re: Copy table from one server to another

Anonymous — Wed, 17 Sep 2014 11:28:12 GMT

Both the target and the source DBs are on an MS SQL server.
@jlolling: Die on error is not checked and still nothing gets inserted...

Re: Copy table from one server to another

Anonymous — Wed, 17 Sep 2014 16:45:37 GMT

Because you are "Using an existing connection" you have changed Talend's transaction mode from implicit to explicit, meaning you must now specify the commit on that connection using a tMSSQLCommit after your tMSSQLOutput. If you are not sharing existing connections, then each component will create and use its own connection and auto-commit when finished.

Re: Copy table from one server to another

Anonymous — Wed, 17 Sep 2014 20:53:28 GMT

Exactly this is the problem!
@ cihanc83 you miss my point. It is recommended to set this option to get the error messages.
You have to add the tMSSqlCommit (triggered by the tMSSqlInput_1 with OnSubjobOk) and you have to add the tMSSqlRollback + tDie triggered with OnSubjobError also from tMSSqlInput_1.

Re: Copy table from one server to another

Anonymous — Thu, 18 Sep 2014 08:35:17 GMT

Thanks for the help. I'll try those and update the thread.