解决系统从Oracle到Sybase的迁移 , M2 Y+ o0 I$ K* @: ]# ^. h: ]
目的:解决系统从Oracle到Sybase的迁移。
# N0 s0 b% X: z1 `8 A# B 命令纵览: - r) [( \" G" k4 ^( G5 U" [+ J
C:\Documents and Settings\newuesr>isql -help
" H$ ]1 o% V0 w Syntax Error in ’-help’. ; S6 ^% o$ _, }) W- M/ {- {
usage: isql [-b] [-e] [-F] [-p] [-n] [-v] [-X] [-Y] [-Q]
* H8 t- [3 K) V; e [-a display_charset] [-A packet_size] [-c cmdend] [-D database]
- W% Z8 \: `3 `" T. Y; X3 {1 s; {: J [-E editor [-h header [-H hostname [-i inputfile] 2 U+ `% y1 p+ ]2 `
[-I interfaces_file] [-J client_charset] [-K keytab_file]
1 m; y4 T2 t) F; l( p [-l login_timeout] [-m errorlevel] [-M labelname labelvalue]
! Q2 Z4 i# q8 Z y# h9 E3 L- Z [-o outputfile] [-P password] [-R remote_server_principal]
4 L" P" t+ s4 h& D+ V [-s col_separator] [-S server_name] [-t timeout] [-U username]
+ ^! R, x, \# q: W. \* e- H [-V [security_options]] [-w column_width] [-z localename] 6 [' _$ u, i2 H$ s# j3 l
[-Z security_mechanism]
7 ?4 L& y9 u1 ]- E
8 \2 J8 O" n J; `( T, D6 T 登录到指定ip地址的数据库里面: ( q, R; C6 H' T/ K3 E9 s) f
isql -H 192.168.3.143 -U sa -P zfvims -D zfv -S newuser
, i. u+ v6 L- G! x3 E% B2 V C:\Documents and Settings\newuesr>isql -H 192.168.3.143 -U sa -P zfvims -D zfv -S newuser 6 N* w# Y5 G$ a7 y" g
9 |1 t3 O2 h# B A
接着创建表进行测试:
" P. S& F; B8 ?* I5 j5 r% h 1> create table test(mom varchar(20)) # }( J1 }5 W, r4 ]4 M) E
2> insert into test values(’aaa’)
* Q/ e1 c- c' u( M$ g 3> insert into test values(’bbb’)
, ~( [: Y0 \- e; @. n 4> insert into test values(’ccc’)
, D/ P. i2 V. \. v5 r) _# Y 5> select * from test . m5 X9 j. m6 y; m0 a% D$ f
6> go # K( ? \0 i8 }$ n) ^
(1 row affected) * P1 `# ~7 V' G$ ^
(1 row affected)
' V; j' f5 a. D. f5 n$ x (1 row affected) 0 }, b( F' D( D* H
mom , @, u) ]! O; p" o9 m) m
--------------------
& A4 V; b* S L( \$ Y9 Y1 W0 M7 v aaa 8 S4 g+ Y7 D7 D3 f+ f
bbb
3 X$ _9 f+ v7 O9 \4 X9 ?, q ccc 5 S$ i X2 x1 j1 `4 c; F0 K
(3 rows affected)
: B% X) S- N5 R; K+ d& x" l, A4 o 1> |