请教一个导数据的问题？？？？
<font size="3">各位大虾能帮一下小弟吗，，，我想把sybase的数据移植出来，例如把<span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">以</span><span lang="EN-US" style="FONT-SIZE: 14pt; FONT-FAMILY: "Times New Roman"; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">hi</span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman"; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">开头的表、关于事件所使用的表。移植到其他数据库或者移植到另外一个sybase数据库，具体的操作是怎样呢？？？小弟没用过sybase，所以不知所醋，大家帮帮忙!!!!</span></font> <p>如果有要用到sql，那要怎么写？？？/</p> 你可以用bcp来批量导出导入 <p>试一下：</p><p>导出：select 'bcp database..'+name+' out '+name+'.out'+' -Usa -P -c -Jcp850 -Sservername'</p><p>from sysobjects where name like 'hi%' and type='U'</p><p>导入：select 'bcp database..'+name+' in '+name+'.out'+' -Usa -P -c -Jcp850 -Sservername'</p><p>from sysobjects where name like 'hi%' and type='U'</p>
页:
[1]