sql server和sybase中通用的使用BCP倒出当前库中所有表的数据批处理脚本

sql server是sybase的儿子，所以 和sybase一样两者中都有BCP工具,使用这个工具可以大容量导入或者导出数据..以下就这两类数据库中的倒出所通用的一个BCP批处理..

@echo off
set server=testdb

set user=sa
set password=

echo use testdb > tabinfo.txt
echo go >>tabinfo.txt
echo select name from sysobjects where type =''U'' order by name >>tabinfo.txt
echo go >>tabinfo.txt

isql -S%server% -U%user% -P%password% -i tabinfo.txt -o out.txt

echo begin bcp out > bcpout.log
echo begin bcp out
for /F "eol=( skip=2 delims= " %%i in (out.txt) do echo %%i & bcp testdb.dbo.%%i out %%i -k -n -S%server% -U%user% -P%password% >>bcpout.log
echo " "  >>bcpout.log
echo finish bcp out >> bcpout.log
echo bcp out finish, for result to see bcpout.log

del tabinfo.txt
del out.txt

pause