解决系统从Oracle到Sybase的迁移

2012-11-12
  目的:解决系统从Oracle到Sybase的迁移。
  命令纵览:
  C:/Documents and Settings/newuesr>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/newuesr>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>
  更多优质资料尽在考试大论坛 考试大在线题库 oracle认证更多详细资料</A
分享到:
0
相关阅读
友情链接
© 2018 我考网 http://www.woexam.com 中国互联网举报中心 湘ICP备18023104号 京公网安备 11010802020116号
违法和不良信息举报:9447029@qq.com