robocopy

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

jamesb2

Thread Starter
Joined
Dec 8, 2007
Messages
126
We are looking to migrate a SQL database to a new server. The database is for an imaging software and has pointers to the images. We are going to move the database in the next week or two. I wanted to start copying the image files to the new server to prepare for the migration (about 300 gig of 17k files). I understand that robocopy is a good program to accomplish this. I am looking to copy all the files, folders, and subfolders over, then copy only the changes over nightly. What is the correct command line that I should use to accomplish this? Can I save it to a bat file and use windows task scheduler to have it run nightly?

Thanks in advance for all of the help!
 
Joined
Apr 29, 2006
Messages
4,393
Are you migrating to a server that will be running the same software? Why not use an SSIS package? That way, you can migrate the complete database to the new server and just point your programs as necessary.
 

jamesb2

Thread Starter
Joined
Dec 8, 2007
Messages
126
Becuase at this point, I am strickly looking to copy files...
 
Joined
Apr 29, 2006
Messages
4,393
We are looking to migrate a SQL database to a new server. The database is for an imaging software and has pointers to the images. We are going to move the database in the next week or two. I wanted to start copying the image files to the new server to prepare for the migration (about 300 gig of 17k files). I understand that robocopy is a good program to accomplish this. I am looking to copy all the files, folders, and subfolders over, then copy only the changes over nightly. What is the correct command line that I should use to accomplish this? Can I save it to a bat file and use windows task scheduler to have it run nightly?

Thanks in advance for all of the help!
Sorry, missed the bolded part.I've never used robocopy but here is a reference: http://technet.microsoft.com/en-us/library/cc733145(v=ws.10).aspx

And yes, mostly anything that you can run in command line can be run as a scheduled .bat.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top