解决系统从Oracle到Sybase的迁移
X9 R" j+ ~) @) g 目的:解决系统从Oracle到Sybase的迁移。 4 q7 D/ \: ^$ N) c/ b' c7 q
命令纵览: 1 |6 n' \2 p% g5 a7 t
C:\Documents and Settings\newuesr>isql -help 7 Q% F- g8 Y' ^, F: I
Syntax Error in ’-help’.
; R, S! G' V0 ?* ` usage: isql [-b] [-e] [-F] [-p] [-n] [-v] [-X] [-Y] [-Q] - X! O0 Q" _$ ` e% G; f
[-a display_charset] [-A packet_size] [-c cmdend] [-D database]
9 K: J1 @2 P. w$ F+ l [-E editor [-h header [-H hostname [-i inputfile] - j, P) s, m/ l1 F4 \4 t5 z( y
[-I interfaces_file] [-J client_charset] [-K keytab_file] 3 f8 I8 W* g0 ~7 q5 N$ p( t
[-l login_timeout] [-m errorlevel] [-M labelname labelvalue]
& Z5 H7 Q y3 i5 k [-o outputfile] [-P password] [-R remote_server_principal] + X P4 e3 V9 N, V5 z- j
[-s col_separator] [-S server_name] [-t timeout] [-U username] # `# d8 `9 ?3 m5 m3 q2 e) Y
[-V [security_options]] [-w column_width] [-z localename]
4 Q( s7 r6 y% S- M [-Z security_mechanism]
8 [; ]2 r% i g5 }
- J% X3 E! Z |; H$ J 登录到指定ip地址的数据库里面:
' G4 l( x' J+ l# O% X" m isql -H 192.168.3.143 -U sa -P zfvims -D zfv -S newuser 3 f B/ B5 g! [+ J" K! w# o, K
C:\Documents and Settings\newuesr>isql -H 192.168.3.143 -U sa -P zfvims -D zfv -S newuser
& e7 V- Q m9 D3 y
! n& M+ G0 ~1 w7 E 接着创建表进行测试:
# }* Q3 W: V( p3 p& {. I- [" j6 r 1> create table test(mom varchar(20)) 4 |. Y; V. A6 z, E2 @& E
2> insert into test values(’aaa’) 4 x" x" b) F |+ p; u3 s' p. F
3> insert into test values(’bbb’)
% `( L" F5 L- J7 o) y 4> insert into test values(’ccc’) + ?3 F3 Q6 {* Q9 f7 a' |
5> select * from test - Q K( P6 a3 f- \6 Z3 r
6> go
% s9 C; K" X8 S* i (1 row affected) , ?, { c/ K) l9 ^; G
(1 row affected)
+ s2 Y" n( {" E3 F4 C7 k (1 row affected) o+ o3 m' [: e
mom % f) ]0 q* L! P" j
-------------------- . t5 a Y1 P. A, q6 C9 o0 J& g. \+ B
aaa
& S( C5 x6 r+ B# W$ X: g bbb
- C8 c/ r4 ^4 n' N* R) ~ ccc 5 ~1 ?( O% P6 |1 f- O* b
(3 rows affected) : J+ ^! i1 X' q c4 {) U! Q
1> |