命令行登录
isql -Sservername -Usa -P
- 安装字符集
charset -Usa -Ppassword -Sservername binary.srt utf8
charset -Usa -Ppassword -Sservername nocase.srt utf8 - 设置字符集
sp_configure 'default charac',173 - 设置排序
sp_helpsort
sp_configure 'default sortorder_id',101 - Sybase数据库数据和日志空间不能自动扩展,需要手工管理。
- 数据库备份恢复
dump database dbname to "c://xxx.dmp" --注意文件生成在数据库服务器端
load database dbname from "c://xxx.dmp"
online database dbname - 表数据备份恢复
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 - 在isql中执行脚本文件
isql -Usa -P -Sservername -Ddbname -iInputfile -oOutputfile - 配置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 - 创建数据库
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