从数据库中把所有表数据导出: 1.编辑一个文件selectout.sql： set nocount on
use databasename
go
select 'bcp databasename..' + name + ' out d:\temp\' + name + '.txt -Uusername -Ppassword -Sservername -c ' from sysobjects where type='U'
go
isql -Uusername -Ppassword -Sservername -i d:\selectout.sql -o d:\bcpout.bat
bcp DatabaseName.dbo.tableName out D:\tableName.txt -SServerName -Usa -P -c -b 10000
bcp DatabaseName.dbo.tableName in D:\tableName.txt -SServerName -Usa -P -c -b 10000
posted on 2012-04-24 14:16
cuilihui 阅读(2528)
评论(0) 编辑 收藏