迁移syslogins表时出现cs_convert
迁移数据库:源数据库 os--scounixsybase11.9
目标数据库 os--windowxp sybase11.9
迁移syslogins表数据
导出:
$ bcp master..syslogins out /u/sybase/syslogins -Usa -Pcwsybase -Jiso_1 -c
Starting copy...
23 rows copied.
Clock Time (ms.): total = 1 Avg = 0 (23000.00 rows per sec.)
$
导入
D:\songybtemp>bcp master..syslogins in d:\songybtemp\syslogins -Usa -P -Jiso_1 -
c
Starting copy...
CSLIB Message:- L0/O0/S0/N24/1/0:
cs_convert: cslib user api layer: common library error: The conversion/operation
was stopped due to a syntax error in the source field.
CSLIB Message:- L0/O0/S0/N36/1/0:
cs_convert: cslib user api layer: common library error: The result is truncated
because the conversion/operation resulted in overflow.
CSLIB Message:- L0/O0/S0/N24/1/0:
cs_convert: cslib user api layer: common library error: The conversion/operation
was stopped due to a syntax error in the source field.
两个表的结构有点不一样。
目标库中的syslogins比源库syslogins多一个字段(srvname vachar(30) 可以为空)。
请大家帮忙解决一下。 推荐用PB来处理。
首先将源库里的数据导成TXT文件;
再连接目标库,SELECT XX1,XX2(与源库结构一致的部分) FROM syslogins 然后可以将源TXT导入了。
页:
[1]