Sybase常用命令

 

命令行登录
isql -Sservername -Usa -P

1. 安装字符集
   charset -Usa -Ppassword -Sservername binary.srt utf8
   charset -Usa -Ppassword -Sservername nocase.srt utf8
2. 设置字符集
   sp_configure 'default charac',173
3. 设置排序
   sp_helpsort
   sp_configure 'default sortorder_id',101
4. Sybase数据库数据和日志空间不能自动扩展，需要手工管理。
5. 数据库备份恢复
   dump database dbname to "c://xxx.dmp"    --注意文件生成在数据库服务器端
   load database dbname from "c://xxx.dmp"   
   online database dbname
6. 表数据备份恢复
   bcp dbname..tablename {out|in} c:/XXX -Usa -Ppassword –Sservername -Jutf8 –c -y
   use dbname
   go
   select 'bcp dbname..' + name + ' out c:/' + name + ' -Usa -P -Ssname -c' from sysobjects where type = 'U'
   go
7. 在isql中执行脚本文件
   isql -Usa -P -Sservername -Ddbname -iInputfile -oOutputfile
8. 配置Adaptive Server核心参数
   sp_configure "max online engines", 1 go
   sp_configure "max memory", 393216 go
   sp_configure "number of user connections", 300 go
   sp_configure "number of open objects", 1500 go
   sp_configure "number of open indexes", 1000 go
   sp_configure "lock wait period", 300 go
   sp_configure "number of devices", 20 go
   sp_addserver 'SYB_BACKUP',NULL,'SYB_BACKUP' go
9. 创建数据库
   disk init name ="dbname", physname="d:/sybase/data/dbname.dat", size=262144 go
   disk init name ="dbname_log", physname="d:/sybase/data/dbname_log.dat", size=524288 go
   create database DBNAME on dbname = 512 log on dbname_log = 1024 go
   sp_addlogin dbname, dbname,DBNAME,us_english use DBNAME go
   sp_changedbowner dbname go