Transferring Data Between Servers

#1

I need to append data from a database on one server to a table in a database
on a different server. Both servers are running SQL 7. How can that be done?

Thanks.

#2

How about creating a linked server, then accessing the other server
directly.

Regards

Colin Dawson
www.cjdawson.com

"Neil" <nospam (AT) nospam (DOT) net> wrote

Quote:

I need to append data from a database on one server to a table in a
database on a different server. Both servers are running SQL 7. How can
that be done?

Thanks.

#3

Thanks.

"Colin Dawson" <newsgroups (AT) cjdawson (DOT) com> wrote

Quote:

How about creating a linked server, then accessing the other server
directly.

Regards

Colin Dawson
www.cjdawson.com

"Neil" <nospam (AT) nospam (DOT) net> wrote in message
news:lwM9g.2267$x4.972 (AT) newsread3 (DOT) news.pas.earthlink.net...
I need to append data from a database on one server to a table in a
database on a different server. Both servers are running SQL 7. How can
that be done?

Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Transferring Data Between Servers

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Transferring Data Between Servers - 05-14-2006 , 03:35 PM

Re: Transferring Data Between Servers - 05-14-2006 , 04:04 PM

Re: Transferring Data Between Servers - 05-15-2006 , 02:46 AM