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

sql sql-server-2008 diagram entity-relationship powerdesigner
aden picture aden · May 22, 2011 · Viewed 26.4k times · Source

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?

Answer

pascal picture pascal · May 23, 2011

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).

Related questions

How to remove diagramming support objects from SQL Server?

I need to remove diagramming support tables, stored procs, views, etc from SQL Servrer using TSQL script. Is there such a script available? SQL 2005 and 2008.

Read More
How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More
How to Delete using INNER JOIN with SQL Server?

I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, Line 15 Incorrect syntax near the keyword 'INNER'. My code: DELETE FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' …

Read More