Sybase数据备份之BCP用法简介[1]

BCP一般存放在所安装的ASE或者Open Client 的BIN目录中版本以前的ASEbcp存放目录为 $SYBASE/bin版本（含版本）以后存放目录为 $SYBASE/OCS_x/bin其中$SYBASE为SYBASE安装目录_x代表版本显示为_或者_可执行文件名称为bcpEXE

参数列表如下（可用 bcp – 得到）

usage: bcp [[database_name]owner]table_name[:slice_number] {in | out} datafile

[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] [q datafile_charset] [z language] [v]

[A packet size] [J client character set]

[T text or image size] [E] [g id_start_value] [N] [X]

[M LabelName LabelValue] [labeled]

[K keytab_file] [R remote_server_principal]

[V [security_options]] [Z security_mechanism] [Q]

常用数据备份格式为

[] [] []