progress升级心得(8.3到10.2b)

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/