bat备份数据库

rem 判断日期文件是否存在
if exist D:\SQLBF\%date:~0,4%%date:~5,2%%date:~8,2% (
rd /s /q D:\SQLBF\%date:~0,4%%date:~5,2%%date:~8,2%
)
ren 创建文件夹
md D:\SQLBF\%date:~0,4%%date:~5,2%%date:~8,2%
cd /d D:\sqlbf\%date:~0,4%%date:~5,2%%date:~8,2%
rem bcp 库名..表名 out 输出路径\文件名 -c -U登录名 -P密码 -SIP
bcp OIW_29965..ashare_ordwth  out ashare_ordwth_29965.txt  -c -Usa -Phbzq -S10.105.a.aaa
bcp OIW_29965..ashare_ordwth2 out ashare_ordwth2_29965.txt -c -Usa -Phbzq -S10.105.a.aaa
bcp OIW_29965..ashare_cjhb    out ashare_cjhb_29965.txt -c -Usa -Phbzq -S10.105.a.aaa

bcp OIW_29965..reqresp out reqresp_29965.txt -c -Usa -Phbzq -S10.105.a.aaa
bcp OIW_29965..execreport out execreport_29965.txt -c -Usa -Phbzq -S10.105.a.aaa
bcp OIW_29965..pubdata out pubdata_29965.txt -c -Usa -Phbzq -S10.105.a.aaa
bcp OIW_29965..externalrefdata out externalrefdata_29965.txt -c -Usa -Phbzq -S10.105.a.aaa
dir