ü 修改E-R模型,同步数据库
新增字段EMAIL:
选择菜单Database>Modify Database..,弹出Database Modification对话框, 并按确定后执行画面如下:(注意如果要直接生成到DB中, 则应选择ODBC generation选项)
ü POWERDESIGN中的执行日志:
|
Database Generation Generation: Check model starting... Generation: Check model successful. Sorting objects... Sort completed. Script Generation... Dropping Indexes... -> Index: PRIMARY (PRIMARY) Dropping Tables... -> Dropping columns of the table user (user)... Creating Tables... -> Creating columns of the table user (user)... -> Column: email (email) -> Creating indexes of the table user (user)... Dropping Indexes... Dropping Tables... Creating Tables... Script Generation completed Generation successful
Usage: (1) Start command prompt (2) Go to the directory D:/project-src/hibernate-workspace/document/ (3) Start the SQL interpreter: mysql.exe (4) Run the database creation script: mysql> source crebas.sql Modification of database successful |
本文介绍如何使用PowerDesign修改E-R模型并同步至数据库的过程。具体步骤包括选择菜单Database>Modify Database,执行日志显示从检查模型、排序对象到生成脚本的完整流程。最后通过SQL解释器运行创建数据库的脚本。

被折叠的 条评论
为什么被折叠?



