Previous  Top  Next

A Physical Data Model can be connected and connection-less.


You can start any new PDM connection less and attach it to the current database session to make it connected.


When a PDM is connection less, you can modify all properties of the objects and design your database freely.


When a PDM has a connection, you can drag tables from your existing database to the Workspace or create new tables into the diagram. However, these will NOT be created in the database unless you extract the DDL for these tables and run it in the database.


You can create a new diagram from an existing database by attaching to the database session.


You can update an existing diagram from a modified database by using the following steps:

1.Establish a database session
2.Open the Diagram Editor
3.Attach to a database session
4.Load the diagram file into the current session


See also: PDM to Database