命令研究覆盖

目的：解决系统从Oracle到Sybase的迁移。

命令纵览：

C:Documents and Settingsnewuesrisql -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 Settingsnewuesrisql -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

查看本文来源