声明:博客内所有技术性文章都是由作者本人工作经验的总结, 实现过程中有搜索资料为参考的绝不涉嫌抄袭,均为个人习惯的总结。
今天要说的是用脚本实现从ftp下载当前目录和子目录,按照原来的目录结构存储到本地,并且用脚本实现自动更新sql脚本,把结果输出到一个文本文件,一下为脚本内容:
@echo off
cls
setlocal EnableDelayedExpansion
set curdir=%~dp0
goto :tmpdir
set /p ftpip=(Enter your ftp domain)
set /p ftpuser=(Enter your ftp account)
set /p ftppw=(Enter your ftp password)
set /p downloaddir=(Enter directory name for download sql script exmple:2.2.2)
:tmpdir
set ftpip=bjd02
set ftpuser=rmmsoftuser
set ftppw=rmmsoftuser
set downloaddir=2.1.9
(
echo;open %ftpip%
echo;user %ftpuser%
echo;%ftppw%
echo;cd "Datebase update srcipt\%downloaddir%"
rem //cancel interactive mode,immediate overwrite
echo;prompt
echo;dir
echo;bye
) > "FTP_Log.ftp"
ftp -n -s:"FTP_Log.ftp" | find "<DIR>" > dirfile.t
::del /q /s "FTP_Log.ftp"
for /f "tokens=1,2,3,4,5*" %%i in (dirfile.t) do (
md %%l
echo %%l
if %%l==" " (echo get nothing
) else (call :downfile %%l)
)
:downfile
set subdir=%1
(
echo;open %ftpip%
echo;user %ftpuser%
echo;%ftppw%
echo;cd "Datebase update srcipt\%downloaddir%\%subdir%"
echo;lcd "%subdir%"
rem //cancel interactive mode,immediate overwrite
echo;prompt
echo;mget *.sql
echo;bye
) > "FTP_Log.ftp"
ftp -n -s:"FTP_Log.ftp"
cd %subdir%
for /r %subdir% %%e in (*.sql) do (
echo. >> 1.txt
echo. >> 1.txt
echo %%e >> 1.txt
osql.exe -S . -d RMMSystem_xqliu -U sa -P "8ik,9ol." -i %%e >> 1.txt
)
cd ..
结束,,,恭喜你可以实现sql脚本自动化更新了
交流QQ:444048361
今天要说的是用脚本实现从ftp下载当前目录和子目录,按照原来的目录结构存储到本地,并且用脚本实现自动更新sql脚本,把结果输出到一个文本文件,一下为脚本内容:
@echo off
cls
setlocal EnableDelayedExpansion
set curdir=%~dp0
goto :tmpdir
set /p ftpip=(Enter your ftp domain)
set /p ftpuser=(Enter your ftp account)
set /p ftppw=(Enter your ftp password)
set /p downloaddir=(Enter directory name for download sql script exmple:2.2.2)
:tmpdir
set ftpip=bjd02
set ftpuser=rmmsoftuser
set ftppw=rmmsoftuser
set downloaddir=2.1.9
(
echo;open %ftpip%
echo;user %ftpuser%
echo;%ftppw%
echo;cd "Datebase update srcipt\%downloaddir%"
rem //cancel interactive mode,immediate overwrite
echo;prompt
echo;dir
echo;bye
) > "FTP_Log.ftp"
ftp -n -s:"FTP_Log.ftp" | find "<DIR>" > dirfile.t
::del /q /s "FTP_Log.ftp"
for /f "tokens=1,2,3,4,5*" %%i in (dirfile.t) do (
md %%l
echo %%l
if %%l==" " (echo get nothing
) else (call :downfile %%l)
)
:downfile
set subdir=%1
(
echo;open %ftpip%
echo;user %ftpuser%
echo;%ftppw%
echo;cd "Datebase update srcipt\%downloaddir%\%subdir%"
echo;lcd "%subdir%"
rem //cancel interactive mode,immediate overwrite
echo;prompt
echo;mget *.sql
echo;bye
) > "FTP_Log.ftp"
ftp -n -s:"FTP_Log.ftp"
cd %subdir%
for /r %subdir% %%e in (*.sql) do (
echo. >> 1.txt
echo. >> 1.txt
echo %%e >> 1.txt
osql.exe -S . -d RMMSystem_xqliu -U sa -P "8ik,9ol." -i %%e >> 1.txt
)
cd ..
结束,,,恭喜你可以实现sql脚本自动化更新了
交流QQ:444048361
转载于:https://blog.51cto.com/19840202/1069812