Solved

copy and move files using either vbscript or powershell or bat if need be

Posted on 2014-12-29
4
254 Views
Last Modified: 2015-01-04
I have a workstation that runs an app connected to some mdb files.  I need to create a script to copy and paste these files from the workstation to a network share.  Windows 7 backup is already being utilized for imaging so I can't use windows backup to backup and move the files to the share.
I want to create a script that copies and moves the files to a network share on a schedule.
I would like to use powershell but my knowledge is limited
vbscript and .bat would be fine.

the data is store on the local machine in a directory that is not a shared directory.  can I grab the files using some sortof $ share designator and then drill into the folder that contains the data?  

example.  no shares on the workstation.   the data is stored in  lets say.  c:\diagram\new
can I run the script on my workstation (not the in place workstation with the data) and move the files to the network share?
0
Comment
Question by:jamesmetcalf74
  • 2
  • 2
4 Comments
 

Author Comment

by:jamesmetcalf74
ID: 40522358
There are 3 computers in play
1) my workstation where I would like to run the script from
2) production workstation where the app and data are running.  -data not in a network share
3) the server in the datacenter where I want to copy the files to
0
 
LVL 23

Accepted Solution

by:
NVIT earned 500 total points
ID: 40522373
Since source folder is not shared, you'll need admin rights to mdb folder:

copy "\\mdbhost\c$\folder\*.mdb" "\\datacenter\folder"

Open in new window


Note:
- The above will overwrite existing mdb files at "\\datacenter\folder"
- Does not consider that the mdb files may be locked (in use)
- To run it periodically, use Task Scheduler
0
 

Author Comment

by:jamesmetcalf74
ID: 40522421
thanks newvillage... can I also run the script using different credentials?
The above example is just a .bat file correct?
0
 
LVL 23

Expert Comment

by:NVIT
ID: 40522462
Revised: Added /c argument

Yes, a .bat file. In Task Scheduler...
Actions, Program/script: cmd
Add arguments: /c batfilename.bat

For your creds:
General, Run whether user is logged on or not, Change User or Group
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I met Paul Devereux (@pdevereux) today when I responded to his tweet asking “Anybody know how to automate adding files from disk to a folder in #outlook  ?”.  I replied back and told Paul that using automation, in this case scripting, to add files t…
It is becoming increasingly popular to have a front-page slider on a web site. Nearly every TV website,  magazine or online news has one on their site, and even some e-commerce sites have one. Today you can use sliders with Joomla, WordPress or …
Learn the basics of if, else, and elif statements in Python 2.7. Use "if" statements to test a specified condition.: The structure of an if statement is as follows: (CODE) Use "else" statements to allow the execution of an alternative, if the …
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now