网站 › 『 Sybase Other 』 › 请教一个导数据的问题？？？？

addson 发表于 2007-5-22 10:04:29

请教一个导数据的问题？？？？

<font size="3">各位大虾能帮一下小弟吗，，，我想把sybase的数据移植出来，例如把<span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-bidi-font-family: &quot;Times New Roman&quot;; 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: &quot;Times New Roman&quot;; 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: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-bidi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">开头的表、关于事件所使用的表。移植到其他数据库或者移植到另外一个sybase数据库，具体的操作是怎样呢？？？小弟没用过sybase，所以不知所醋，大家帮帮忙!!!!</span></font>

addson 发表于 2007-5-22 10:05:28

<p>如果有要用到sql，那要怎么写？？？/</p>

zzw9908 发表于 2007-5-22 18:16:27

你可以用bcp来批量导出导入

zzw9908 发表于 2007-5-22 18:19:29

<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+'&nbsp;in '+name+'.out'+' -Usa -P -c -Jcp850 -Sservername'</p><p>from sysobjects where name like 'hi%' and type='U'</p>

查看完整版本: 请教一个导数据的问题？？？？