move the files

Question

Post reply

move the files

charipg

SSCrazy Eights

Points: 9888
More actions
August 13, 2009 at 10:22 am

#133910

how to move the files from one server to another server?

Viewing 15 posts - 1 through 15 (of 23 total)

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

murthykalyani SSCarpal Tunnel Points: 4500 More actions · Answer 1

open the desired location in windows explorer and source in another window in explorer then copy and paste.

charipg SSCrazy Eights Points: 9888 More actions · Answer 2

i want to copy through xp_cmdshell ?

what is the command.............

RBarryYoung SSC Guru Points: 143329 More actions · Answer 3

To copy files from the command level? The command is "COPY".

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

charipg SSCrazy Eights Points: 9888 More actions · Answer 4

in server1 , file is C:\folder1

i want to copy that file in server2 , file is D:\folder2

pls give the complete command.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 5

charipg (8/13/2009)
in server1 , file is C:\folder1
i want to copy that file in server2 , file is D:\folder2
pls give the complete command.

I'm curious. What is your position in your organization and how is it that you do not know how to copy a file? Please give us complete details.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

htt SSCertifiable Points: 5242 More actions · Answer 6

charipg (8/13/2009)
in server1 , file is C:\folder1
i want to copy that file in server2 , file is D:\folder2
pls give the complete command.

dude, you are in wrong forum I believe.

charipg SSCrazy Eights Points: 9888 More actions · Answer 7

master..xp_cmdshell 'copy C:\folder1 \\ + @Server1 '

is it correct?

RBarryYoung SSC Guru Points: 143329 More actions · Answer 8

charipg (8/13/2009)
master..xp_cmdshell 'copy C:\folder1 \\ + @Server1 '
is it correct?

Still waiting for an answer to my question ...

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Jayakumar Krishnan SSCarpal Tunnel Points: 4710 More actions · Answer 9

Write your question clearly and easy to understandable, then only the forum members can help you to resolve the issue.

Do you want to copy a file inside SQL using xp_cmdshell?

Use the below.

master..xp_cmdshell 'Copy c:\folder1\Test.txt d:\Folder2\'

Thanks
Jay
http://www.sqldbops.com

charipg SSCrazy Eights Points: 9888 More actions · Answer 10

EXEC xp_cmdshell 'copy c:\folder1\file1

\\server2\folder2\file1, NO_OUTPUT';

correct?

charipg SSCrazy Eights Points: 9888 More actions · Answer 11

charipg

SSCrazy Eights

Points: 9888

August 13, 2009 at 12:08 pm

#1038900

thanks ............got it.............

RBarryYoung SSC Guru Points: 143329 More actions · Answer 12

charipg (8/13/2009)
EXEC xp_cmdshell 'copy c:\folder1\file1
\\server2\folder2\file1, NO_OUTPUT';
correct?

still waiting ...

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

charipg SSCrazy Eights Points: 9888 More actions · Answer 13

i am new to sql..........first time i am using extended sp.............

thanks.............

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 14

There are other ways to move files between servers without using xp _ cmdshell. Would you please explain what you are trying to accomplish and why you think it has to be done from with T-SQL using xp _ cmdshell?

Off topic for anyone interested, I could not post the above comment with the spaces removed from around the underscore character. This only occurs here at work on both of my desktop systems. Go figure.