Copy Files From Server to Server

Question

Copy Files From Server to Server

Timothy Moore

SSC Veteran

Points: 264
More actions
April 18, 2007 at 11:08 am

#118188

I have files being stored on a Shared folder on one server, and need to copy those files over to the share on My other server. What would the T-SQL look like to achieve this?

Thanks,
NoOB

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

David McFarland SSChampion Points: 11815 More actions · Answer 1

Assuming that this is a repeating process, I'd create a batch file, using UNC names, and call that with xp_cmdshell. Then, any changes you want to make only need to be made in the batch file.

If it's a one time thing, I'd bypass T-SQL completely and let the OS do it.

Timothy Moore SSC Veteran Points: 264 More actions · Answer 2

im setting up a procedure to move the file on a daily basis as a new file is loaded in that folder daily

David McFarland SSChampion Points: 11815 More actions · Answer 3

Then I'd personally go with the batch file. You can even call it from a job if you'd like.

Timothy Moore SSC Veteran Points: 264 More actions · Answer 4

but what would the batch file look like. stuck on the syntax

David McFarland SSChampion Points: 11815 More actions · Answer 5

XCOPY \\sourceserver\sourcevolume\sourcepath\sourcefilename \\destinationserver\destinationvolume\destinationpath\destinationfilename

You can use COPY instead of XCOPY, but I use XCOPY as it gives more switches that I may or may not need down the road.

Timothy Moore SSC Veteran Points: 264 More actions · Answer 6

Timothy Moore

SSC Veteran

Points: 264

April 18, 2007 at 11:34 am

#701193

awesome, thank you very much