Copy table from one server to another

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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!

[Anonymous]

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

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

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...

[Anonymous]

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.