Can I run bulk insert or bcp on a local server to insert data into a
remote server?
What are the other options to Push data to a remote server outside a
firewall?
Bulk insert is only for insert purposes -- you would need to run this on the
remote server. BCP does in/out. In theory you could run this from your
machine (with a file on your PC) and specify the remote server as the
destination.
You might be able to use replication or custom built insert statements that
utilize linked servers for connectivity.
Keith Kratochvil
"Rishi" <mrrishisharma@.gmail.com> wrote in message
news:1159992378.416088.171020@.b28g2000cwb.googlegr oups.com...
> Can I run bulk insert or bcp on a local server to insert data into a
> remote server?
> What are the other options to Push data to a remote server outside a
> firewall?
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment