DOS工具：快速导入数据库表的工具

刺骨的言语ヽ痛彻心扉 2022-09-28 15:22 126阅读 0赞

@echo off  
rem -- =============================================  
rem -- DESCRIPTION: <自動\_導入バッチ>  
rem -- AUTHOR:      <>  
rem -- CREATE DATE: <2010/12/27>  
rem -- =============================================

rem --------------------------------------------------------------  
rem         コピー元タイプ\_(default: txt)  
rem --------------------------------------------------------------  
@SET file\_type1=.txt

rem -------------------------------------------------------------  
rem         from\_データベース\_\_name  
rem -------------------------------------------------------------  
@SET from\_database\_name=\[project\_guest126\_back\].\[dbo\]

rem -------------------------------------------------------------  
rem         to\_データベース\_\_name  
rem -------------------------------------------------------------  
@SET to\_database\_name=\[project\_guest126\].\[dbo\]

rem -------------------------------------------------------------  
rem         テーブル\_\_name  
rem -------------------------------------------------------------  
@SET table\_name=.\[Z\_M\_PART\_STK\_WK\]

rem -------------------------------------------------------------  
rem         CONFIGファイル名  
rem -------------------------------------------------------------  
@SET config\_file\_name=CONFIG.TXT

rem -------------------------------------------  
rem         SQLサーバへデータが 導入成功  
rem -------------------------------------------  
@FOR /F "eol=\# tokens=1,2,3\* delims=, " %%i IN (%config\_file\_name%) DO (  
BCP %to\_database\_name%%table\_name% in %from\_database\_name%%table\_name%%file\_type1% -S%%i -U%%j -P%%k -c>>log.txt  
IF errorlevel 1 GOTO error  
)

@echo -- =============================================  
@echo    データが 導入成功しました。  
@echo -- =============================================

@GOTO end  
@:error

@echo -- =============================================  
@echo データが 導入失敗しました。  
@echo -- =============================================  
@GOTO end  
@:end

\---------------------------------

\----------------------------------

config.txt的内容

192.168.0.62,sa,password