程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> SyBase數據庫 >> SyBase綜合文章 >> 最近一段時間都在弄sybase和ms-sqlserver,寫了一份學習筆記

最近一段時間都在弄sybase和ms-sqlserver,寫了一份學習筆記

編輯:SyBase綜合文章
可能內容有些沒章法。
以前在壇上許過寫份學習資料出來。今天補上。望對學習者有幫助。

簡介:
對學習Sybase和ms-sqlserver的體會,包括安裝、初始化、sql學習,過程和觸發子創建,db-library和ct-library以及同Oracle的不同之處,和細節注意對比。

[不能上傳文件,只好列出內容]
Sybase學習體會
原創:戴黎鳴
第一大塊:Sybase安裝 [redhat 7.2]
Sybase rpm 包安裝順序 12.5.0.1 for Linux
Sybase-common-12.5.0.1DE-1.i386.rpm
Sybase-ase-12.5.0.1ESD-1.i386.rpm
Sybase-efts-12.5.0.1ESD-1.i386.rpm
Sybase-openclIEnt-12.5.0.1ESD-1.i386.rpm
Sybase-esql-12.5.0.1ESD-1.i386.rpm
Sybase-sqlremote-7.0.2-1.i386.rpm
Sybase-chinese-12.5.0.1ESD-1.i386.rpm
安裝
rpm -ivh Sybase-common-12.5.0.3-7.i386.rpm
rpm -ivh Sybase-ase-12.5.0.3-7.i386.rpm [ -Uhv --nodeps]
rpm -ivh Sybase-efts-12.5.0.3-7.i386.rpm [ -Uhv --nodeps]
rpm -ivh Sybase-openclIEnt-12.5.0.3-7.i386.rpm
rpm -ivh Sybase-esql-12.5.0.3-7.i386.rpm
rpm -ivh Sybase-sqlremote-7.0.2-1.i386.rpm
卸載
rpm -e Sybase-efts-12.5.0.3-7
rpm -e Sybase-sqlremote-7.0.2-1
rpm -e Sybase-esql-12.5.0.3-7
rpm -e Sybase-openclIEnt-12.5.0.3-7
rpm -e Sybase-openclIEnt-12.5.0.3-7
rpm -e Sybase-ase-12.5.0.3-7
rpm -e Sybase-chinese-12.5.0.3-7
rpm -e Sybase-doc-12.5.0.3-7
rpm -e Sybase-common-12.5.0.3-7
rpm -ql libstdc++
安裝順序和依賴關系說明:
Sybase-common-12.5.0.1DE-1.i386.rpm The common package is a prerequisite to all other packages. It creates and installs the default runtime environment required by other packages, and includes tools to configure, install, and administer Adaptive Server and related components.
NOTE: The Sybase-common-12.5-3.i386.rpm is a pre-required package. You must install it before you install any other rpm package as all depend on the common package.

Sybase-ase-12.5.0.1ESD-1.i386.rpm This package installs all binary server components required to run Adaptive Server, Backup Server, XP Server, Monitor Server, Historical Server and related utilitIEs and tools for database development and maintenance.

Sybase-efts-12.5.0.1ESD-1.i386.rpm The efts package installs the Enhanced Full-Text Search Specialty Data Store, which provides the capability to do complex searches on character and text d
  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved