Я в процессе преобразования старого сервера SQL (SQL 2005) на работе. Мы должны хранить данные на 7+ лет по закону. Я делаю это с помощью vmware esxi, и он работал совершенно иначе, чем для ограниченного дискового пространства (осталось ~ 36 ГБ). Проблема, однако, в том, что мы обнаружили, что больше не можем получить доступ к базам данных из наших ярлыков. Мы используем пакетные файлы и ярлыки на рабочем столе для этих пакетных файлов.

@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
|источник

0