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 |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2008-03-13 : 10:38:17
|
| OK, not my issue, but someone built a rocket ship with Replication on some very small tables that are out of playI suggested they do a dump and restore of a dev box, but because of replication, the impact will be larger than they wantedSo now they want to bcp out sever multi million row tablesSo I said okThey were going to do it to their local drive, and I said no, use UNC file name to the server itselfNow for the questionI suggested to run this bcp bat file as a job from the server, but the guy doesn't have rightsI found the dba for the box and he's agreed to schedule/run the job BUTWhat happens if a client runs the bcp from his local machine?Does it make a round tri[p or is it smart enough to take the network out of play?SQL 2k btwBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-03-13 : 12:39:29
|
| BCP is a client app, so I think the data has to go to the client.Same if you run DTS or SSIS on a client.CODO ERGO SUM |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
bcp