Click here to Skip to main content
15,033,303 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi there,

I have a server called with an ip adress( and I would like to send my data files to another server which is with an ip of
The username of the server to which I will send the data to is user2 and password pass2.
(This is just an example to highlight)

How can I connect it?
I need to send the data after every 5 hours each day.

Best regards ...

I would appreciate if I could get an explanation of how the code works ?

Many thanks
Updated 7-Feb-11 22:25pm
Sandeep Mewara 8-Feb-11 3:46am
Any effort from your side?
Dalek Dave 8-Feb-11 4:26am
Edited for Grammar and Readability.

To be honest, I wouldn't write it myself: I'd use a backup program instead.
Assuming it is just data then there are no end of commercial copy or backup programs available, why reinvent the wheel?

For SQL try along the lines of...

INSERT INTO [server2].[database2]..states
SELECT statename FROM [server1].[database1]..states

Or a variation thereof.

Otherwise why not just post it as a webservice and have a second server just pick up the data directly?

Lots of options.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900