Transferring Data Between Servers

[Neil]

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.

[Colin Dawson]

Re: Transferring Data Between Servers

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

Regards

Colin Dawson

https://www.cjdawson.com

"Neil" <nospam@nospam. net> wrote in message
news:lwM9g.2267 $x4.972@newsrea d3.news.pas.ear thlink.net...[color=blue]
>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.
>[/color]

[Neil]

Re: Transferring Data Between Servers

Thanks.

"Colin Dawson" <newsgroups@cjd awson.com> wrote in message
news:CXM9g.6929 8$wl.20939@text .news.blueyonde r.co.uk...[color=blue]
> How about creating a linked server, then accessing the other server
> directly.
>
> Regards
>
> Colin Dawson
> www.cjdawson.com
>
> "Neil" <nospam@nospam. net> wrote in message
> news:lwM9g.2267 $x4.972@newsrea d3.news.pas.ear thlink.net...[color=green]
>>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.
>>[/color]
>
>[/color]