![](https://csdnimg.cn/release/download_crawler_static/27191319/bg3.jpg)
Sybase iq数据库迁移
- 2 -
2.3 采用操作系统直接输出到当前运行端
SELECT * FROM employee>& empfile
其中:
> # < 文件名 > 输出执行结果
> & < 文件名 > 输出到文件包括错误信息和执行信息,执行结果
>>表示在文件之后追加数据
usage:
select * from table1>#D:\WZ\table1.csv;
2.4 采用 bcp 程序批量导出
SybaseIQ 支持 BCP,可以有两种方式,一种是通过 OCS提供的 BCP,语法和
ASE类似,还有一种是通过 iq_bcp ,语法如下:
usage:
iq_bcp [[database_name.]owner.]table_name {in | out} datafile
[-c] [-t field_terminator] [-r row_terminator]
[-U username] [-P password] [-I interfaces_file] [-S server]
[-v] [-A packet size] [-J client character set]
usage:
bcp [[db_name.]owner.]table_name[:slice_num] [partition pname] {in |
out} [filename]
[-m maxerrors] [-f formatfile] [-e errfile]
[-F firstrow] [-L lastrow] [-b batchsize]
[-n] [-c] [-t field_terminator] [-r row_terminator]
[-U username] [-P password] [-I interfaces_file] [-S server]
[-a display_charset] [-z language] [-v]
[-A packet size] [-J client character set]
[-T text or image size] [-E] [-g id_start_value] [-N] [-X]