powerdesigner从概念模型生成物理模型并导出sql生成数据库

1、3.1.openPowerdesigner21Object却DcwerDesigner-CDMnmn/巳nerve-E:riierve.cclmFileEditViewModelSymbolReportRepositoryToolsWindowJ远3日皿|必昌|為晦嚣X|旳CCategoryCheckLocationWorkspacer-Ennen/ener*e曰费nen/e*囲nen/eDomains0-jlDataItems|區Entities-?pnere*囲nen/elEil-i_JDomainsl+ll-i_JTablesj.T卜匚、打川貝m44a4*T土二H(”j|FindXChe

2、ckModeI/2.ve.cdmartRepository/Tool&lWindowHelpLocationCompleteLink&Ctrl+F5CheckModel.F4mpad:andLineageAnalysis.Ctrl+FILCo-mpareModels.Ctrl+FSMergeModel.,&hift+F&ExtendedGeneration.GenerationLinksSpellCheckingOptions.ExecuteCo-rnmandsMappingEdito-r.-.GnerateCon匚巳pILilDataModel.Ctrl+hift4-CGenerateLog

3、icalD-ataModel.Ctrl4-Shift4-LCtrl-I-Shift-I-PLicenseParameters.DataModel.,Res口urces5E)牛PDMGenerationOptionsDBMS:MySQL5.DSharetheDBMSdefinition匚口口)theDBMSdefinitioriinmodelnerve2Name:Code:nen/82ConfigureMade!Options.oUpdateewisbingj-hsicaIDataModelDBMS:My-SQL5.0应用血率助GeneralPreservemodificationsSelect

4、modelj1n&nxeD&tailT：=d-tMedalsSelctii-nGeneratenewPhysicalDataModelSymbol圈固匣定占FileEditViewModeleportRepositcPowerDesigner-PDMne-rve,nerveJw日戲|及日I為贬32d二Workspace盅nervenerveCstegoyCheckLctiQnJIObject一一_匚.*iiZI.IA.d”_FindXCheckModel/Database爭硒nerve*Qnerveitl-JDomairis(+)JDataIterns丄亩”Entitiesnerve*屯ine

5、rve|电_|DomainF1-jTables7.対PoveD巳！signer-PDIMnervefnerve-E:nerve.pdm和FileEditViewModelSymbol1JDatabaseReportRepositoryToolsWindowHelpJJ|A(J|圈血囲|BlE|匮慣CategoryCheckFindXCheckModel/CnaniaeCurrentDBMS.EditCJtrentDEMS.DefaultPtyfcalOptions.13寻nerateDatabase.、ApplyModelChangestoDatab呂se,UpdateModelfromDat

6、abase.Ctrl4-GCtrl+REstimateDatabaseSize.GenerateTestData.GnerateExtractionScripts.Ctrl+Shift4-DLExecuteSQL.Ctrl4-Shift4-EConfigureCQnnection&.Connect.Disconnect.ConnectionInformation.Ctrl+Shift4-NObjnen/enerveEl-DomainsDataItemsEntitiesqJWorkspacenerve1-固琳一II由“LjI电“一iE)-?nerve:”固nerveE)-._JDomains-J

7、TablesnerveDirectory:Filename:Generationtype:*ScriptgenerxDefauftr圍Settingsset:QuicklaunchSelection:Op+iunsFijrmitSpineti&nSunirTi：=d-yMySQLDBMS:crebas.gqlDirectgeneration11.9.8.bloodbph曲trfNvicat8forMySQLFileViewTookWindowHelpConnectionsConnectionManageUsersNdvicat8forMySQLFileViewTookWindow上Connec

8、tionManageUsersConnectiQnsbloodbphcdscervixerfcrf_24Sermdemodepressd亡pr亡吕stestdepresstest_l-dietglucabayglucoba-gmatrhinfbrmatian為isitpXjngodkdennicamaimeimimimsmysqlf-0nerve10.NewDatabase.LOpenDatabfiseCloseDatabaseRefreshTl11UU口ITyOumpSQLFile.二*PrintDatabase,DataTrsnE.fer.f-QiManageUs日：“9.12.9.Fil

9、eViewTools.WindowStoredProoCornectionMl吕仃ageUsersConnectionsViewsStoredPraceduresEventscervixerferf2AOpenTdble/DesignTablne_case!-:he-diniC-follawupine_first_diagnasis1ne_fbllowup_drugs_det3il1ne_past_diagnosis_detail1ne_past_Mamination_detailHn亡_tr亡目tn亡nt_dLigs_(j亡t日il1ne_adr靈如打depressdepresstest扌depresstesi