下次修改 | 前次修改
最後一次修改
兩邊的下次修訂版 |
sybase:move [2011/12/12 17:34] – 建立 jal | sybase:move [2011/12/13 03:37] – jal |
---|
安裝過程不贅述,但是記得確認下列資訊 | 安裝過程不贅述,但是記得確認下列資訊 |
- page size 如果沒有要升級,記得設定為一樣 | - page size 如果沒有要升級,記得設定為一樣 |
- | |
<code> | <code> |
isql -Usa -SSybaseServer -w1000 -e -n | isql -Usa -SSybaseServer -w1000 -e -n |
- master.sysusages | - master.sysusages |
| |
| <code> |
| sp_configure "allow updates", 1 |
| |
| bcp master..syslogins in D:\backup\20111210\syslogins_20111210_modify.txt -Usa -Ssybase -b 1 -c |
| bcp master..syssrvroles in D:\backup\20111210\syssrvroles_20111210_modify.txt -Usa -Ssybase -b 1 -c |
| bcp master..sysloginroles in D:\backup\20111210\sysloginroles_20111210.txt -Usa -Ssybase -b 1 -c |
| |
| update sysservers set srvnetname='SYBASE_BS' where srvid=1 |
| |
| |
| |
| disk init name = "MIS_T_data01", physname = "D:\sybase\data\MIS_T_data01.dat", size = "2G" |
| disk init name = "MIS_T_data02", physname = "D:\sybase\data\MIS_T_data02.dat", size = "2G" |
| disk init name = "MIS_T_data03", physname = "D:\sybase\data\MIS_T_data03.dat", size = "2G" |
| disk init name = "MIS_T_data04", physname = "D:\sybase\data\MIS_T_data04.dat", size = "2G" |
| disk init name = "MIS_T_data05", physname = "D:\sybase\data\MIS_T_data05.dat", size = "2G" |
| disk init name = "MIS_T_data06", physname = "D:\sybase\data\MIS_T_data06.dat", size = "2G" |
| disk init name = "MIS_T_log01", physname = "D:\sybase\data\MIS_T_log01.dat", size = "2G" |
| disk init name = "MIS_T_log02", physname = "D:\sybase\data\MIS_T_log02.dat", size = "2G" |
| disk init name = "MIS_T_log03", physname = "D:\sybase\data\MIS_T_log03.dat", size = "2G" |
| disk init name = "MIS_T_log04", physname = "D:\sybase\data\MIS_T_log04.dat", size = "2G" |
| |
| |
| CREATE DATABASE MIS_T ON MIS_T_data01 = '2G', MIS_T_data02 = '2G', MIS_T_data03 = '2G', MIS_T_data04 = '2G', MIS_T_data05 = '2G', MIS_T_data06 = '2G' log ON MIS_T_log01 = '2G', MIS_T_log02 = '2G', MIS_T_log03 = '2G', MIS_T_log04 = '2G' for load |
| |
| |
| CREATE DATABASE MIS_T ON MIS_T_data01 = '2G' log ON MIS_T_log01 = '2G' |
| ALTER DATABASE MIS_T ON MIS_T_data02 = '2G' log ON MIS_T_log02 = '2G' |
| ALTER DATABASE MIS_T ON MIS_T_data03 = '2G' log ON MIS_T_log03 = '2G' |
| ALTER DATABASE MIS_T ON MIS_T_data04 = '2G' log ON MIS_T_log04 = '2G' |
| ALTER DATABASE MIS_T ON MIS_T_data05 = '2G' |
| ALTER DATABASE MIS_T ON MIS_T_data06 = '2G' |
| |
| LOAD DATABASE MIS_T from "D:\backup\20111210\MIS_T_20111210060114.dmp" |
| </code> |
| |
待續 | 待續 |