欢迎来到天天文库
浏览记录
ID:27585697
大小:1.20 MB
页数:8页
时间:2018-12-03
《pd反向工程导出数据库结构》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、PD反向工程导出数据库结构bytsonghuaPowerdesigner反向工程(ReverseEngineer)川‘以连接数据库,然后导出其数据库结构(表、视图等),然后加以分析、设计等。比如,这里可以通过2种方式来反向Oracle数据库结构1脚本1.1.用toad连接,在SchemaBrowser下,选中需要导出的表,右键,选CreateScript,生成脚本。如下图:53Tables
2、3、escriptsCS_ACHI_BRANCH_TCS.ACHI_CASE.AREAJCSACHICASETCS.AUTH_SURV_QUAL.DICCS_BPrPE_LUSE_CORR_OICCS_CASE_COMMBfr_DICCS_CASE.COMMENTJTCS_CASE.CORRELAT1VE_TCS.CASEJTYPE.DICCS_CHARGEJ)ICCS.CHARGE^SUMMARYJ-CSCHATGEDETAILTMBCS.CHECK.CASE.TCS.CHECK.POIMrS.DICC4、S.CHECK^POINrSJ-CS.CHECK.R£SUIT_DICcs.cuen-.TCS^COMMONPHRASESJTCS一CONSJXXZ-TCS_CONS_DOC_TYPE_DICCS.CORP.EQUIP.TCS_CORP_GRAD6JTCS.CORP.PROP.DICCS.CORP.TCS_CORP_VALIJ)ICCS_CORPPER.QUAL.DICCS_CORPP®-TCS_DATA_OPER_DICCS_DOC.CAIEJ)ICCSDOCFROMOICTaUeOptionsSc5、nptOptionsDrectOutputTo:OCipboardFlenamecmiiFvnnifIOutputOScreenF:eMaDtsonghuafl91229test2.SGlCnt:120Output118SelectedTablesAddtoProjectAddtoSBFavoritesList胃AnalyzeTftbl«洛Auditin6、iles(onefileperobject)yjuseRelativePathr*BwWATSoOSeparateFles(onefilepertable)PathCASESURVEYGCOREBASE芳CreateScriptCjCr““T^bl««»bCr«^teSynonjflhsDisableAllDropTibleAllZstin4t«Size▽FilterTablesKebuildIndexes龟IAsShowRwCountT«bl«CustonQueriesCASESURVEY®uu〜u7、EJExecutejCancel—ToadforOracle-[CASESDRVEYUCOREBASE—SchesaBrowser(CASESURVEY)】1fileEditSeaichfindEditorSessionDatabaseDebugyiewUtiltieseBijWindowHelp朱•▼吃,JtsEdtorSchemaBro^Aser為CASESUR^EYvGeneralCASESURVEYgCOREBASE>09:44:27Infb:OCXExtractComple8、te.1.2打开PD,新建一个PhysicalDataModelPoverDesignerFileEditWindowS3A况嚙鼸XJ*J!ModelNewmodelHewmodelfromBusinessProcessModel^ConceptualDataModel法FreeModdInforwatiorLiquidityModel吟:Ot^ectOrientedModelExtendedModelDefinitionsIPhysicalDataModel」Modelname:(ORACLEVew9、on9i2SharetheDBMSdefnition•CopyIheDBMSdefinitioninmodelDBMSRequirementsModdXMLModelFirstdiagram:PhysicalDiagram确定取消nysicalDataModelFileEditViewModaSymbolReportKeposiloryToolsIfindoNrHelpChftngoCurrentDBMSEditCurrentDBUSD«£aultPhy
3、escriptsCS_ACHI_BRANCH_TCS.ACHI_CASE.AREAJCSACHICASETCS.AUTH_SURV_QUAL.DICCS_BPrPE_LUSE_CORR_OICCS_CASE_COMMBfr_DICCS_CASE.COMMENTJTCS_CASE.CORRELAT1VE_TCS.CASEJTYPE.DICCS_CHARGEJ)ICCS.CHARGE^SUMMARYJ-CSCHATGEDETAILTMBCS.CHECK.CASE.TCS.CHECK.POIMrS.DICC
4、S.CHECK^POINrSJ-CS.CHECK.R£SUIT_DICcs.cuen-.TCS^COMMONPHRASESJTCS一CONSJXXZ-TCS_CONS_DOC_TYPE_DICCS.CORP.EQUIP.TCS_CORP_GRAD6JTCS.CORP.PROP.DICCS.CORP.TCS_CORP_VALIJ)ICCS_CORPPER.QUAL.DICCS_CORPP®-TCS_DATA_OPER_DICCS_DOC.CAIEJ)ICCSDOCFROMOICTaUeOptionsSc
5、nptOptionsDrectOutputTo:OCipboardFlenamecmiiFvnnifIOutputOScreenF:eMaDtsonghuafl91229test2.SGlCnt:120Output118SelectedTablesAddtoProjectAddtoSBFavoritesList胃AnalyzeTftbl«洛Auditin6、iles(onefileperobject)yjuseRelativePathr*BwWATSoOSeparateFles(onefilepertable)PathCASESURVEYGCOREBASE芳CreateScriptCjCr““T^bl««»bCr«^teSynonjflhsDisableAllDropTibleAllZstin4t«Size▽FilterTablesKebuildIndexes龟IAsShowRwCountT«bl«CustonQueriesCASESURVEY®uu〜u7、EJExecutejCancel—ToadforOracle-[CASESDRVEYUCOREBASE—SchesaBrowser(CASESURVEY)】1fileEditSeaichfindEditorSessionDatabaseDebugyiewUtiltieseBijWindowHelp朱•▼吃,JtsEdtorSchemaBro^Aser為CASESUR^EYvGeneralCASESURVEYgCOREBASE>09:44:27Infb:OCXExtractComple8、te.1.2打开PD,新建一个PhysicalDataModelPoverDesignerFileEditWindowS3A况嚙鼸XJ*J!ModelNewmodelHewmodelfromBusinessProcessModel^ConceptualDataModel法FreeModdInforwatiorLiquidityModel吟:Ot^ectOrientedModelExtendedModelDefinitionsIPhysicalDataModel」Modelname:(ORACLEVew9、on9i2SharetheDBMSdefnition•CopyIheDBMSdefinitioninmodelDBMSRequirementsModdXMLModelFirstdiagram:PhysicalDiagram确定取消nysicalDataModelFileEditViewModaSymbolReportKeposiloryToolsIfindoNrHelpChftngoCurrentDBMSEditCurrentDBUSD«£aultPhy
6、iles(onefileperobject)yjuseRelativePathr*BwWATSoOSeparateFles(onefilepertable)PathCASESURVEYGCOREBASE芳CreateScriptCjCr““T^bl««»bCr«^teSynonjflhsDisableAllDropTibleAllZstin4t«Size▽FilterTablesKebuildIndexes龟IAsShowRwCountT«bl«CustonQueriesCASESURVEY®uu〜u
7、EJExecutejCancel—ToadforOracle-[CASESDRVEYUCOREBASE—SchesaBrowser(CASESURVEY)】1fileEditSeaichfindEditorSessionDatabaseDebugyiewUtiltieseBijWindowHelp朱•▼吃,JtsEdtorSchemaBro^Aser為CASESUR^EYvGeneralCASESURVEYgCOREBASE>09:44:27Infb:OCXExtractComple
8、te.1.2打开PD,新建一个PhysicalDataModelPoverDesignerFileEditWindowS3A况嚙鼸XJ*J!ModelNewmodelHewmodelfromBusinessProcessModel^ConceptualDataModel法FreeModdInforwatiorLiquidityModel吟:Ot^ectOrientedModelExtendedModelDefinitionsIPhysicalDataModel」Modelname:(ORACLEVew
9、on9i2SharetheDBMSdefnition•CopyIheDBMSdefinitioninmodelDBMSRequirementsModdXMLModelFirstdiagram:PhysicalDiagram确定取消nysicalDataModelFileEditViewModaSymbolReportKeposiloryToolsIfindoNrHelpChftngoCurrentDBMSEditCurrentDBUSD«£aultPhy
此文档下载收益归作者所有