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 myserver1.com with an ip adress(192.168.1.5) and I would like to send my data files to another server which is server2.com with an ip of 192.168.100.5.
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 ...

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

Many thanks
Posted
Updated 7-Feb-11 22:25pm
v2
Comments
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...

SQL
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