怎样将.bcp文件导入sybase数据库
------解决方案--------------------------------------------------------
使用bcp导出导入Sybase库的数据
- SQL code
---COut.txt select 'bcp RealGDCOURT.dbo.' + name + ' in ' +'D:\bcp\' +name + ' -Usa -P -Ssybase238 -n' from sysobjects where type = 'U' andgo--CIn.txtuse realGDCOURTgoselect 'bcp RealGDCOURT.dbo.' + name + ' out ' +'D:\bcp\' +name + ' -Usa -P -Ssybase238 -n' from sysobjects where type = 'U'go--在Cmd上输入如下语句,生成out.bat和in.batIsql -Usa -P -Ssybase238 -i COut.txt -o out.batIsql -Usa -P -Ssybase238 -i CIn.txt -o In.bat--执行out.bat将数据导出--执行in.bat将数据导入