Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2014-12-29
4
Medium Priority
?
263 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 25

Accepted Solution

by:
NVIT earned 2000 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 25

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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

I hope you'll find this tutorial useful and interesting. So let's try to extend Tcl with a new package.  For anyone more deeply interested please check out the book "Practical Programming in Tcl and Tk". It's really one of the best written books abo…
Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
Learn the basics of while and for loops in Python.  while loops are used for testing while, or until, a condition is met: The structure of a while loop is as follows:     while <condition>:         do something         repeate: The break statement m…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

722 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