How to generate SQL tables from ER diagram in Power Designer 15? [closed]

Closed. This question is seeking recommendations for books, tools, software libraries, and more. It does not meet Stack Overflow guidelines guidelines. It is not currently accepting answers.

---

开发者_运维问答

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 8 years ago.

Improve this question

I want to generate Sql tables from ER diagram in Powerdesigner ,but ,I don't know how can i do that? Which Tools i should use?

---

I guess you have a Conceptual Data Model to represent your ER diagram.

You first need to generate a Physical Data Model from it, using Tools > Generate Physcical Data Model, picking the specific DBMS you want to use, Microsoft SQL Server 2008, available for PD 15.0 and up.

And then generate the script using Database > Generate Database as mentionned in the first comment.

The need to convert the ER diagram into a Physical DAta Model, is that the ER diagram could use some concepts which need to be resolved before going to SQL; and miss some concept specific to the databaase implementation (like performance indexes).