Copy data from one SQL Server database table to the other

[help_lucky]

 

 

I don't know how to copy table data from

 

one server -> database -> table

 

TO

 

other sever -> database -> table.

 

If it is with in the same server and different databases, i have used the following

SELECT * INTO DB1..TBL1 FROM DB2..TBL1 (to copy with table structure and data)

INSERT INTO DB1..TBL1(F1, F2) SELECT F1, F2 FROM DB2..TBL1 (copy only data)

 

Now my question is copy the data from SERVER1 --> DB1--> TBL1 to SERVER2 --> DB2 -->TBL2

 

[trq]

Does this need to be done programatically? Its easy enough to do through enterprise manager otherwise.