目的:解决系统从Oracle到Sybase的迁移。
命令纵览:
C:Documents and Settings ewuesr>isql -help
Syntax Error in "-help".
usage: isql [-b] [-e] [-F] [-p] [-n] [-v] [-X] [-Y] [-Q]
[-a display_charset] [-A packet_size] [-c cmdend] [-D database]
[-E editor [-h header [-H hostname [-i inputfile]
[-I interfaces_file] [-J client_charset] [-K keytab_file]
[-l login_timeout] [-m errorlevel] [-M labelname labelvalue]
[-o outputfile] [-P password] [-R remote_server_principal]
[-s col_separator] [-S server_name] [-t timeout] [-U username]
[-V [security_options]] [-w column_width] [-z localename]
[-Z security_mechanism]
登录到指定ip地址的数据库里面:
isql -H 192.168.3.143 -U sa -P zfvims -D zfv -S newuser
C:Documents and Settings ewuesr>isql -H 192.168.3.143 -U sa -P zfvims -D zfv -S newuser
接着创建表进行测试:
1> create table test(mom varchar(20))
2> insert into test values("aaa")
3> insert into test values("bbb")
4> insert into test values("ccc")
5> select * from test
6> go
(1 row affected)
(1 row affected)
(1 row affected)
mom
--------------------
aaa
bbb
ccc
(3 rows affected)
1>