请问：如何把数据库表中的数据保存为一个sql文件？

[am2000]

[am2000]

to hansonman(何百万):里面的数据没有吧

[am2000]

to pbdesigner(MIS/ERP开发):这样每次只能保存一个表啊　

[am2000]

另外，我在用powerdesigner生成测试数据的时候，生成的脚本数据为乱码：请大虾指点一二：

insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('Z
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('Y
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('?
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('D蒒
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('S?
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('?
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('?
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('S
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('XD
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('?
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('14??
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('?
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' ', 'BC65?
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 0', '
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 1', '?
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 2', '?
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 3', '錜K?
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 4', '
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 5', '
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 6', 'G?
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 7', '
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 8', '
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 9', '?
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' A', '叚
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' B', 'N?
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' C', '?
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' D', '8慪
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' E', '
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' F', '
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' G', '诱燉
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' H', 'M
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' I', '0

[dian]

你要这个干嘛，如果是为了以后导入，当心执行不完就死掉，当数据过多、文本过长时会无法执行完毕（好象是SQLSERVER）

[wangsw]

用得着那么折腾吗？

[hansonman]

design--->start log
object--->export systex to log (可加很多表)
design--> save log as (保存为sql 文件)

[pbdesigner]

PB7:在该表上弹右键，edit data,菜单row\save row as(选sql文件类型）

[guest007]

在7.0下
右键此表，export syntax,就OK了

[guest007]

看错题目了，呵呵
同意楼上

[hansonman]

上面三层说的是pb6.5