Estou no processo de conversão de um antigo servidor sql (sql 2005) no trabalho. Precisamos manter os dados por mais de sete anos por lei. Eu estou fazendo isso usando vmware esxi e funcionou perfeitamente diferente do espaço limitado em disco (~ 36GBs de espaço restante). O problema, porém, é que descobrimos que não podemos mais acessar os bancos de dados de nossos atalhos. Usamos arquivos em lote e atalhos na área de trabalho para esses arquivos em lote.
@ECHO OFF
REM v2.1 modified 090325 by Gregg
color f4
TITLE Checking for Visual 2000 upgrade.
REM Searches for all the "v2k*.txt" files in the Deploy folder
REM and look if they exist on the local machine. If at least one doesn't,
REM then the deployment is made and files are copied.
REM There should be only one file called "v2k*.txt"
REM Set the folder for the correct deploy folder here:
set VisualDrive=C:
set LocalFolder=C:\Documents and Settings\%USERNAME%\Visual 2000\v2k_Lanctot\
set DeploySource=D:\Visual 2000\Deploy\v2k_Lanctot
%VisualDrive%
cls
if exist "%LocalFolder%" goto ExistingUser
:CreateUser
echo No user folder found. Creating new user...
md "%LocalFolder%"
md "%LocalFolder%\temp"
md "%LocalFolder%\v2ktemp"
md "%LocalFolder%\EDI"
md "%LocalFolder%\EDI\Archive"
md "%LocalFolder%\EDI\Error"
md "%LocalFolder%\EDI\In"
md "%LocalFolder%\EDI\Out"
:ExistingUser
echo Local folder: %LocalFolder%
echo Deploy folder: %DeploySource%
cd "%LocalFolder%"
echo ******************************************************************************
echo Checking for deploy folder
if exist "%DeploySource%" goto CheckMarker
echo Deploy source %DeploySource% not found
pause > NUL
goto END
:CheckMarker
echo Checking for deploy version file
if exist "%DeploySource%\v2k*.txt" goto CheckFiles
echo Version file not found
pause > NUL
goto END
:CheckFiles
echo Checking for changes...
FOR %%A IN ("%DeploySource%\v2k*.txt") DO IF NOT EXIST "%LocalFolder%\%%~xnA" GOTO DEPLOY
GOTO end
:DEPLOY
color 88
color 99
color aa
color bb
color cc
color dd
color ee
color ff
color f4
echo ******************************************************************************
echo ** **
echo ** **
echo ** Visual 2000: New files found.... **
echo ** **
echo ** **
echo ** Please leave this window open while new files are copied. **
echo ** **
echo ** **
echo ******************************************************************************
echo *** This process may take several minutes ***
echo ******************************************************************************
TITLE !! Updating Visual 2000 files - DO NOT CLOSE THIS WINDOW !!
echo Updating files for %username%[%USERDOMAIN%/%SESSIONNAME%] from %CLIENTNAME% on %date% at %time% >> Usage.txt
IF EXIST "%LocalFolder%\v2k*.txt" DEL "%LocalFolder%\v2k*.txt"
COPY "%DeploySource%\dsn.v2k*" "%LocalFolder%" /y
COPY "%DeploySource%\*.mde" "%LocalFolder%" /y
COPY "%DeploySource%\*.txt" "%LocalFolder%" /y
goto DONE
:END
echo No changes found.
:DONE
Title Starting Visual...
echo *
echo Starting Visual. Please stand by...
echo *
echo %username%[%USERDOMAIN%/%SESSIONNAME%] from %CLIENTNAME% on %date% at %time% >> Usage.txt
start /D "%LocalFolder%\%Company%" "C:\Program Files\Common Files\Microsoft Shared\access runtime\Office10\MSACCESS.EXE /runtime" "%LocalFolder%\%Company%\visual 2000.mde"
if %errorlevel% == 0 exit
echo !REFUSED %username%[%USERDOMAIN%/%SESSIONNAME%] from %CLIENTNAME% on %date% at %time% >> Usage.txt
pause
exit