rem for /F "tokens=1" %%i in ('"DIR /S /B /OD c:\QuickBackups\VEPROMS_20*.bak"') DO SET _FileName=%%i
rem echo Restore "%_FileName%"
rem sqlcmd -E -S.\sqlexpress -b -Q "restore database [VEPROMS_JCB1] from disk = '%_FileName%'"
rem if ERRORLEVEL 1 PAUSE
rem call wait 3
rem if errorlevel 1 pause
rem ping 1.0.0.0 -n 1 -w 2000 > NUL
sqlcmd -I -E -S.\sqlexpress -d VEPROMS -i "C:\Development\Proms\SQL\PROMS2010.SQL"
PAUSE
rem ping 1.0.0.0 -n 1 -w 2000 > NUL
sqlcmd -I -E -S.\sqlexpress -d VEPROMS -i "C:\Development\Proms\SQL\PROMStoCM.sql"
PAUSE