dos sql批处理工具

比眉伴天荒 2022-06-18 01:27 168阅读 0赞

echo off  
@cls  
@color

rem -- =============================================  
rem -- DESCRIPTION: <自動一括作成SQLバッチ>  
rem -- AUTHOR:  <>  
rem -- CREATE DATE: <2010/11/25>  
rem -- UPDATE DATE  <2011/08/30> Update 2.0  
rem -- =============================================

rem ----------------------------  
rem         処理種類  
rem          0：　一括ファイル生成(手動で更新)　  
rem　　　　　1：　各自ファイルをDBへ自動に更新  
rem　　　　　2：　0＋1の処理を一括に行い  
rem ----------------------------  
@set do\_type=2

rem ----------------------------  
rem         Local Folder Name  
rem ----------------------------  
@set local\_build\_dir=build\_sql

rem ----------------------------  
rem         Local File SQL\_Name  
rem ----------------------------  
@set local\_build\_file=SQL一括作成.sql

rem ----------------------------  
rem         sqlserver\_host  
rem ----------------------------  
@set sqlserver\_host=KDC-HS-022

rem ----------------------------  
rem         sqlserver\_database  
rem ----------------------------  
@set sqlserver\_database=duplo\_guest\_0530

rem ----------------------------  
rem         sqlserver\_username  
rem ----------------------------  
@set sqlserver\_username=sa

rem ----------------------------  
rem         sqlserver\_password  
rem ----------------------------  
@set sqlserver\_password=sasa

rem ----------------------------  
rem         Local log Name  
rem ----------------------------  
@set local\_logfile\_name=build.log

rem ----------------------------  
rem         do build  
rem ----------------------------  
@echo ===================================  
@echo build 開始  
@echo ===================================

@set do\_flg=0  
@set str=0

@if exist .\\%local\_logfile\_name% del /q/s/f ".\\%local\_logfile\_name%"

@if %do\_type% EQU 1 goto c

@if exist .\\%local\_build\_dir% @rd /q/s .\\%local\_build\_dir%  
@md .\\%local\_build\_dir%

@for /r .\\ %%a in (\*.sql) do @(  
@if exist %%a @type "%%a" >>.\\%local\_build\_dir%\\%local\_build\_file%  
)

@if %do\_type% EQU 0 goto continue

@:c  
@if not exist .\\%local\_build\_dir%\\%local\_build\_file% @set do\_flg=1

@if %do\_flg% EQU 0 goto a  
@if %do\_flg% EQU 1 goto b  
@:a

@sqlcmd -U %sqlserver\_username% -P %sqlserver\_password% -S %sqlserver\_host% -d %sqlserver\_database% -i ".\\%local\_build\_dir%\\%local\_build\_file%" >>.\\%local\_logfile\_name%  
@if errorlevel 1 call :error "%local\_build\_dir%\\%local\_build\_file%"  
@goto continue

@:b

@for /r .\\ %%a in (\*.sql) do @(  
@if exist %%a sqlcmd -U %sqlserver\_username% -P %sqlserver\_password% -S %sqlserver\_host% -d %sqlserver\_database% -i "%%a" >>.\\%local\_logfile\_name%  
)

@goto continue  
@:error  
@if %1 EQU 0 @del /q/s/f ".\\%local\_logfile\_name%" && goto :eof  
@if %1 GEQ 0 @set str=1 && @color 4f

@echo ===================================  
 @echo ビルド失敗  
 @echo 　　　　⇒ %local\_logfile\_name%　を参照してください  
@echo ===================================  
@goto :eof

@:continue  
@for /r .\\ %%L in (%local\_logfile\_name%) do @(  
if exist %%L call :error %%~ZL  
)

@if %str% EQU 1 goto end

@color 2f  
@echo ===================================  
@echo build 終了  
@echo ===================================

@echo ===================================  
@echo  処理内容：  
@if %do\_type% NEQ 0 (  
@echo  　　　　　全てsqlファイルを【%sqlserver\_host%の%sqlserver\_database%】へ更新成功しました  
)  
@if %do\_type% EQU 0 (  
@echo　　　　　　ビルドファイル【%local\_build\_dir%\\%local\_build\_file%】 ご利用ください  
)

@echo  バージョン情報：  
@echo  作成者：　2010/12 Create 1.0  
@echo  　                2011/08 Update 2.0  
@echo ===================================  
@:end  
@pause  
@goto :eof