batch vs vbs question

ranjitcool

Hey Guys,

I was trying to get the batch script to work, while my manager told me that vbs does the same and is more easier.

But how on earth do i execute a vb script ? Can i type it in a notepad and save it as a .vbs ?

I know a little vb but never used it in this manner.

The following is the batch script of what i am trying to acheive.

Output shud be filename_date.sql

@echo off
:Main
for /F "tokens=2,3,4 delims=/ " %%i in ("%date%") do set d=%%k%%i%%j
echo %d%
mysqldump gradschool > gradschool_%d%.sql
pause

:EndProg
echo *End of file*

please advice me i am very new to windows scripting.

thanks
rj

rbutturini

You can type it in notepad (although it works better in something like notepad++ which is freely downloadable).

to execute the script from the command line type cscript and the file name of the .vbs file you want to run.