Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
 Posted - 2004-12-06 : 07:59:43
|
| I BCP a table out of a server on our DMZ and then need to copy the file to 160ish servers on a seperate domain without any trusts set-up. I cannot set up any trusts. I could connect via SQL Server and Use a DataPumpTask to copy the table across, but this is very slow due to the connection speeds to these servers. The best I have thought of is the file copy method, but with no trusts set-up, this becomes problematic when I try to copy the file to each server. Each server will have the file in the same place and has a standard user/pwd to connect.Please help... |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-12-06 : 08:24:16
|
| Any chance that FTP could be used? It would be simple to script it using the command-line FTP utility.If you can't copy it to all the servers, are there UNC paths that you could copy it to that are visible to them? |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-12-06 : 10:25:03
|
| Unfortunately not.. Neither of those options are viable in this case.. Seems I will have to rethink...Cheers anyway Rob... |
|
|
|
|
|
|
Can anyone think of a quick way to do this?