Oracle SQL Developer Data Modeling 4.0.2.840
The latest version of Oracle SQL Developer Data Modeling v4 - 4.0.2.840 is actually distinct in several ways from the immediate predecessor - v4.0.2.15.21 and earlier releases including a more intuitive navigation system. For example to open a Data Model in earlier releases one had to navigate several levels to File > DataModeler > Open. Now it's just File > Open (as it was in much earlier releases)
Work still needed in certain areas as noted below -
SQL Server 2008 Target RDMS Exported DDL issues -
- Generated DDL contains errors eg DATETIME includes (8) Length option which should be dropped.
- In DDL, Schema Names not showing up in Table Name Prefix for Create or Alter TAble commands
- Schema Names do appear in generated DDL Constraint Names but with period (.) that SQL Server does not accept.
Other issues -
- Cannot copy objects from one design to another, even with the same Model
- Scratchpad SQL Syntax converter still only works from other RDMS to Oracle only, not from Oracle to other RDMS
A big plus and improvement in the v4 series is the Navigation pane which makes it very easy to move around on the the design pallete across larger Data Models without the need for zoom out or slider use.