开发学院数据库Oracle Sybase命令研究 阅读

Sybase命令研究

 2007-05-06 12:07:07 来源:WEB开发网   
核心提示:目的:解决系统从Oracle到Sybase的迁移命令纵览:C:Documents and Settingsleizhimin.TOPNET>isql -helpSyntax Error in '-help'.usage: isql [-b] [-e] [-F] [-p] [-n] [-v] [-X

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

命令纵览:

C:Documents and Settingsleizhimin.TOPNET>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 topicms -D icms -S LEIZHIMIN

C:Documents and Settingsleizhimin.TOPNET>isql -H 192.168.3.143 -U sa -P topicms -D icms -S LEIZHIMIN

接着创建表进行测试:

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>

Tags:Sybase 命令 研究

编辑录入:爽爽 [复制链接] [打 印]
[]
  • 好
  • 好的评价 如果觉得好,就请您
      0%(0)
  • 差
  • 差的评价 如果觉得差,就请您
      0%(0)
赞助商链接