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.