trying copy table to other server (both in the enterprise manager)

[michelleqw]

Dear SQL users,

We are trying to copy a table to an other server database, both servers are in the enterprise manager (2000).Inside the same server it is very easy to copy a table to an other database with the next syntax:

Select * into targetdb.dbo.tbl_a from sourcedb.dbo.tbl_a

Is it possible to copy a table to an other server. If yes, can someone pls give the source?Nice regards,Michelle.

Nice regards,

Michelle.

 

[mrdenny]

To do it via T/SQL you will need to setup a linked server. This can be done within Enterprise Manager.

Open the Server, Security, Linked Servers. Right click on linked servers, and setup the fields as needed.

Once the linked server is setup you can do it from the destination server.

Select * 
into targetdb.dbo.tbl_a 
from [COLOR=red]source_server.[/color]sourcedb.dbo.tbl_a

You can also use the Export Data wizzard to do this.

Or you can create a DTS package manually to do it.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[michelleqw]

We found out that the right syntax is:

[from source_server].sourcedb.dbo.tbl_a

Thanks a lot for your excellent information

Michelle.