1:确定Progress和QAD的安装路径
Progress 10.2B: $DLC=/prog102b/dlc
Progress 8.3E: $DLCOLD=/prog83e
QAD: $MFG=/qad
数据库备份:$QADBAK=/qadbak/db
数据库mfgdb1 mfgdb2
2:确定progress10.2b安装后convmap.cp文件各版本的存储路径
# find / -name convmap.cp –print:
/prog102b/dlc/bin/83dbutils/convmap.cp
/prog102b/dlc/bin/91dbutils/convmap.cp
/prog102b/dlc/bin/101dbutils/convmap.cp
/prog102b/dlc/convmap.cp
3:因数据库由8.3E ->10.2b,则要求将数据库convert 8->9->10
所以在8->9时,需做如下动作
Root#/qad># cd $DLC
Root#/prog102b/dlc># cp convmap.cp convmap.cp-102b
Root#/prog102b/dlc># cp $DLC/bin/91dbutils/convmap.cp /prog102b/dlc/convmap.cp
4:确保原始数据库都为多卷数据库
由prostrct db-name的数据库在改系统中存在mfgdb2为单卷数据库,需要在旧版本里面先转好后转移到测试区,注意
转多卷前需要注意备份的准确性
$dlc/bin/prostrct convert mfgdb2
PLEASE NOTE !! Once started, if the conversion is
interrupted for any reason, your database may be
damaged. Please make a backup before conversion.
Do you want to start the conversion. y/n: y
数据库mfgdb2转换至多量数据库成功。(5085)
如果仍然不行,则最好通过mfgdb.st重建数据库
/prog83e/bin/prodel mfgdb2
/prog83e/bin/prostrct create mfgdb2 mfgdb2.st
/prog83e/bin/procopy /pro83e/prolong/sch/empty mfgdb2
/prog83e/bin/prorest mfgdb2 $QADBAK/mfgdb2
5: 8.3升级到9.1
确定$DLC中的convmap.cp 文件为$DLC/bin/91dbutils/下面的文件(步骤3)
Cd /qad
$DLC/bin/91dbutils/91conv89 /qad/mfgdb1 –C conv89
$DLC/bin/91dbutils/91conv89 /qad/mfgdb2 –C conv89
数据库成功升级到9.1
6:清理9.1的BI文件
Trancate 9.1bs数据,此时DB已经为9版本,所以清资料必须使用9版本的truncate文件
$DLC/bin/91dbutils/91_proutil mfgdb1 –C truncate bi –bi 2048
$DLC/bin/91dbutils/91_proutils mfgdb2 –C truncate bi –bi 1024
执行成功后就可以将数据库再由9.1升级到10.2B了
7:升级之前,将原$DLC下面的convmap.cp文件还原为原来的10.2B版本的map.cpwenjian
Root#/prog102b/dlc># cp convmap.cp-102b convmap.cp
8: 9.1升级到10.2
Cd /qad
$DLC/bin/proutil /qad/mfgdb1 –C conv910 –pf mfglang.pf
$DLC/bin/proutil /qad/mfgdb2 –C conv910 –pf mfglang.pf
9:重建10.2版本的数据库table索引
$DLC/bin/proutil /qad/mfgdb1 –C idxbuild
$DLC/bin/proutil /qad/mfgdb2 –C idxbuild
OpenEdge Release 10.2B as of Mon Dec 14 17:00:24 EST 2009
Index Rebuild Utility
=====================
Select one of the following:
All (a/A) - Rebuild all the indexes
Some (s/S) - Rebuild only some of the indexes
By Area (r/R) - Rebuild indexes in selected areas
By Schema (c/C) - Rebuild indexes by schema owners
By Table (t/T) - Rebuild indexes in selected tables
By Activation (v/V) - Rebuild selected active or inactive indexes
Quit (q/Q) - Quit, do not rebuild
Enter your selection:
A
Do you have enough disk space for index sorting? (y/n)
Y
10:进入数据库
Cd /qad
$DLC/bin/pro mfgdb1
$DLC/bin/pro mfgdb2
查看数据库的版本信息及数据资料
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20846108/viewspace-733789/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20846108/viewspace-733789/