|
知识ID：PowerBT0013
适用版本：4.1、5.0
问题：怎样将MS SQL Server 数据库中Primavera5.0数据和Oracle数据库中数据进行互相移植
解决方案：Primavera4.1,Primavera5.0支持将不同数据库中数据进行互相移植。移植工具为CALM。该工具位于Primavera第一张光盘的\install\database下， 文件名为Calm.exe。
CALM用于从一个存在的数据库重创建一个新的DAF，或者从一个DAF文件中载入数据库。在CALM中有以下功能：
可以从Oracle，SQL Server/MSDE和Interbase中创建DAF文件
可以从DAF中创建和载入新的Oracle，SQL Server/MSDE和InterBase数据库
可以自动更新已经载入的数据库到当前计划中
可以选择载入许可文件_CONFIG数据
可以选择载入ADMIN
运行CALM有两个要求：
DBEpress drivers
ConfigAsst 数据路径
CALM参数说明：
-v Verbose Mode
-m<模式> CALM mode for datapump use “pump”
-C<原串> Source string (see below)
-G<目标串> Target string (see below)
-w Truncate existing database
-a Automatically upgrade
-i<许可文件> Load a license file
-b<xml>,<cfg name> Load ADMIN_CONFIG
CALM运行结果说明：
对程序用户及密码没有改动。
但对数据库连接的密码重置为pubuser/pubuser,privuser/privuser,以及在Oracle中的admuser/admuser。
CALM操作说明：
导出DAF文件
1、 导出ms sql server数据成DAF文件
在光盘中，在DOS窗口中，直接运行CALM.exe这个程序文件。
输入命令如下：
calm -V -mpump -Cdatabase:sa/sa-password@grace:pmdb -Gfile:c:\temp\sql_pmdb.zip
运行结果是在c:\temp下生成一个sql_pmdb.zip文件。
2、 导出Oracle数据成DAF文件
在光盘中，在DOS窗口中，直接运行CALM.exe这个程序文件。
输入命令如下：calm -v -mpump -Cdatabase: admuser/admuser@pmdb50 -Gfile:d:\bak\ora_pmdb50.zip
执行完成之后，在d:\bak目录下生成ora_pmdb50.zip文件。
导入DAF文件
1、 导入DAF文件到MS SQL Server数据库中
首先，确认在ms sql server中没有将要导入的pmdb这个数据库实例。
其次，在光盘中，在DOS窗口中，直接运行CALM.exe这个程序文件。
输入命令如下： calm -V -mpump -Cfile:c:\temp\pmdb.zip -Gdatabase:sa/sa-password@grace:pmdb
运行成功之后,在ms sql server中生成一个pmdb这个数据库。
2 、 导入DAF文件到Oracle数据库中
首先，在要在Oracle中创建一个数据库，然后，在这个数据库中创建PMDB所要的三个表空间：PMDB_DAT1,PMDB_LOB1,PMDB_NDX1。创建方法有两种，可以通过Oracle的图形界面创建，也可以利用Primavera光盘中的Oracle脚本文件的前几个创建表空间语句创建。具体请咨询Oracle DBA。 下面的操作以Prim5已经创建，并已经正常服务。
其次，在光盘中，在DOS窗口中，直接运行CALM.exe这个程序文件。
输入命令如下： calm -v -mpump -Cfile:c:\temp\pmdb.zip -Gdatabase: system/passwordr@Prim5
运行结果如下：
Config Assist Line Mode v5.0.0
Verbose Output Mode
Mode is Datapump
Creating Target Database and Schema...
Clearing Table: WKFLUSER
Clearing Table: WORKFLOW
Clearing Table: WBSSTEP
Clearing Table: WBSRSRC_QTY
Clearing Table: WBSRSRC
Clearing Table: WBSMEMO
Clearing Table: WBSBUDG
Clearing Table: VIEWPROP
Clearing Table: USERWKSP
Clearing Table: USEROBS
Clearing Table: USERENG
Clearing Table: USERDATA
Clearing Table: USERCOL
Clearing Table: UDFVALUE
Clearing Table: UDFCODE
Clearing Table: UDFTYPE
Clearing Table: TRSRCSUM
Clearing Table: TRSRCFIN
Clearing Table: TASKWKSP
Clearing Table: TASKSUM
Clearing Table: TASKPROC
Clearing Table: TASKPRED
Clearing Table: TASKNOTE
Clearing Table: TASKMEMO
Clearing Table: TASKFIN
Clearing Table: TASKFDBK
Clearing Table: TASKDOC
Clearing Table: TASKACTV
Clearing Table: RSRFOLIO
Clearing Table: RSRCSEC
Clearing Table: RSRCROLE
Clearing Table: RSRCRCAT
Clearing Table: RSRCRATE
Clearing Table: SHIFTPER
Clearing Table: RSRCPROP
Clearing Table: RSRCHOUR
Clearing Table: TIMESHT
Clearing Table: TSDATES
Clearing Table: TASKRSRC
Clearing Table: RSRCCURV
Clearing Table: RPTLIST
Clearing Table: RPTBATCH
Clearing Table: ROLERATE
Clearing Table: ROLFOLIO
Clearing Table: RLFOLIO
Clearing Table: RISKCTRL
Clearing Table: RELITEMS
Clearing Table: REITTYPE
Clearing Table: RCATVAL
Clearing Table: RCATTYPE
Clearing Table: QUERYLIB
Clearing Table: PUBUSER
Clearing Table: PRPFOLIO
Clearing Table: PROJWSRPT
Clearing Table: PROJRISK
Clearing Table: RISKTYPE
Clearing Table: PROJPROP
Clearing Table: PROJPCAT
Clearing Table: PROJFUND
Clearing Table: PROJEST
Clearing Table: PROJCOST
Clearing Table: PROFPRIV
Clearing Table: PROCITEM
Clearing Table: PROCGROUP
Clearing Table: PREFER
Clearing Table: PFOLIO
Clearing Table: PCATUSER
Clearing Table: PCATVAL
Clearing Table: PCATTYPE
Clearing Table: NONWORK
Clearing Table: NEXTKEY
Clearing Table: MEMOTYPE
Clearing Table: JOBRPT
Clearing Table: RPT
Clearing Table: RPTGROUP
Clearing Table: JOBSVC
Clearing Table: ITERGOAL
Clearing Table: ITERDAYS
Clearing Table: ISSUHIST
Clearing Table: PROJISSU
Clearing Table: WORKSPACE
Clearing Table: TASK
Clearing Table: PROJTHRS
Clearing Table: TRAKVIEW
Clearing Table: THRSPARM
Clearing Table: GCHANGE
Clearing Table: FUNDSRC
Clearing Table: FORMPROJ
Clearing Table: FORMTMPL
Clearing Table: FORMCATG
Clearing Table: FILTPROP
Clearing Table: FACTVAL
Clearing Table: FACTOR
Clearing Table: EXPPROJ
Clearing Table: EXTAPP
Clearing Table: DOCUMENT
Clearing Table: RSRC
Clearing Table: UMEASURE
Clearing Table: SHIFT
Clearing Table: ROLES
Clearing Table: DOCSTAT
Clearing Table: DOCCATG
Clearing Table: COSTTYPE
Clearing Table: CALENDAR
Clearing Table: BUDGCHNG
Clearing Table: PROJWBS
Clearing Table: PHASE
Clearing Table: OBS
Clearing Table: ITERATION
Clearing Table: RELEASE
Clearing Table: RFOLIO
Clearing Table: BRE_REGISTRY
Clearing Table: ADMIN_CONFIG
Clearing Table: ACTVCODE
Clearing Table: ACTVTYPE
Clearing Table: PROJECT
Clearing Table: USERS
Clearing Table: PROFILE
Clearing Table: CURRTYPE
Clearing Table: FINDATES
Clearing Table: BASETYPE
Clearing Table: ACCOUNT
Loading Table: ACCOUNT
Loading Table: BASETYPE
Loading Table: FINDATES
Loading Table: CURRTYPE
Loading Table: PROFILE
Loading Table: USERS
Loading Table: PROJECT
Loading Table: ACTVTYPE
Loading Table: ACTVCODE
Loading Table: ADMIN_CONFIG
Loading Table: BRE_REGISTRY
Loading Table: RFOLIO
Loading Table: RELEASE
Loading Table: ITERATION
Loading Table: OBS
Loading Table: PHASE
Loading Table: PROJWBS
Loading Table: BUDGCHNG
Loading Table: CALENDAR
Loading Table: COSTTYPE
Loading Table: DOCCATG
Loading Table: DOCSTAT
Loading Table: ROLES
Loading Table: SHIFT
Loading Table: UMEASURE
Loading Table: RSRC
Loading Table: DOCUMENT
Loading Table: EXTAPP
Loading Table: EXPPROJ
Loading Table: FACTOR
Loading Table: FACTVAL
Loading Table: FILTPROP
Loading Table: FORMCATG
Loading Table: FORMTMPL
Loading Table: FORMPROJ
Loading Table: FUNDSRC
Loading Table: GCHANGE
Loading Table: THRSPARM
Loading Table: TRAKVIEW
Loading Table: PROJTHRS
Loading Table: TASK
Loading Table: WORKSPACE
Loading Table: PROJISSU
Loading Table: ISSUHIST
Loading Table: ITERDAYS
Loading Table: ITERGOAL
Loading Table: JOBSVC
Loading Table: RPTGROUP
Loading Table: RPT
Loading Table: JOBRPT
Loading Table: MEMOTYPE
Loading Table: NEXTKEY
Loading Table: NONWORK
Loading Table: PCATTYPE
Loading Table: PCATVAL
Loading Table: PCATUSER
Loading Table: PFOLIO
Loading Table: PREFER
Loading Table: PROCGROUP
Loading Table: PROCITEM
Loading Table: PROFPRIV
Loading Table: PROJCOST
Loading Table: PROJEST
Loading Table: PROJFUND
Loading Table: PROJPCAT
Loading Table: PROJPROP
Loading Table: RISKTYPE
Loading Table: PROJRISK
Loading Table: PROJWSRPT
Loading Table: PRPFOLIO
Loading Table: PUBUSER
Loading Table: QUERYLIB
Loading Table: RCATTYPE
Loading Table: RCATVAL
Loading Table: REITTYPE
Loading Table: RELITEMS
Loading Table: RISKCTRL
Loading Table: RLFOLIO
Loading Table: ROLFOLIO
Loading Table: ROLERATE
Loading Table: RPTBATCH
Loading Table: RPTLIST
Loading Table: RSRCCURV
Loading Table: TASKRSRC
Loading Table: TSDATES
Loading Table: TIMESHT
Loading Table: RSRCHOUR
Loading Table: RSRCPROP
Loading Table: SHIFTPER
Loading Table: RSRCRATE
Loading Table: RSRCRCAT
Loading Table: RSRCROLE
Loading Table: RSRCSEC
Loading Table: RSRFOLIO
Loading Table: TASKACTV
Loading Table: TASKDOC
Loading Table: TASKFDBK
Loading Table: TASKFIN
Loading Table: TASKMEMO
Loading Table: TASKNOTE
Loading Table: TASKPRED
Loading Table: TASKPROC
Loading Table: TASKSUM
Loading Table: TASKWKSP
Loading Table: TRSRCFIN
Loading Table: TRSRCSUM
Loading Table: UDFTYPE
Loading Table: UDFCODE
Loading Table: UDFVALUE
Loading Table: USERCOL
Loading Table: USERDATA
Loading Table: USERENG
Loading Table: USEROBS
Loading Table: USERWKSP
Loading Table: VIEWPROP
Loading Table: WBSBUDG
Loading Table: WBSMEMO
Loading Table: WBSRSRC
Loading Table: WBSRSRC_QTY
Loading Table: WBSSTEP
Loading Table: WORKFLOW
Loading Table: WKFLUSER
Dataloader Complete
Process completed successfully. 完成将DAF文件导入到Oracle数据库中。
|
