可能內容有些沒章法。
以前在壇上許過寫份學習資料出來。今天補上。望對學習者有幫助。
簡介:
對學習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