sybase下移動裝置位置

Select * from sysdevices

2 在資料庫中更改裝置位置

use master

go

sp_configure 'allow updates to system tables',1

update sysdevices set phyname='F:\master.dat' where name='master'

update sysdevices set phyname='F:\sybprocs.dat' where name='sysprocsdev'

update sysdevices set phyname='F:\sybsysdb.dat' where name='systemdbdev'

update sysdevices set phyname='F:\log1.dat' where name='log1'

update sysdevices set phyname='F:\data1.dat' where name='data1'

update sysdevices set phyname='F:\data2.dat' where name='data2'

update sysdevices set phyname='F:\data3.dat' where name='data3'

update sysdevices set phyname='F:\data4.dat' where name='data4'

3停止sybase服務，拷貝sybase所有裝置到目标磁盤

E:\data\data1.dat----->F:\data1.dat

E:\data\data2.dat----->F:\data2.dat

E:\data\data3.dat----->F:\data3.dat

E:\data\data4.dat----->F:\data4.dat

E:\data\log1.dat----->F:\log1.dat

E:\master.dat----->F:\master.dat

E:\sybprocs.dat----->F:\sybprocs.dat

E:\sybsysdb.dat----->F:\sybsysdb.dat

4更改sybase安裝路徑RUN_crm.bat中的-de:\master.dat---->-df:\master.dat

通過上文我們可以靈活拷貝裝置來實作資料庫的遷移而不懼于目錄結構的限制！

本文轉自 zhangxuwl 51CTO部落格，原文連結：http://blog.51cto.com/jiujian/1046883，如需轉載請自行聯系原作者