Friday 9 October 2009

Oracle : SQL Developer Data Modeller

Pros
  • Full oracle support
  • Also SQL Server (2005?) and DB2
  • Java based so linux too
  • Data model v.similar to Designer
  • Reverse engineer and generate scripts
  • Diff ?
  • No db required - xml files - so portable
  • Repository in the offing
Cons
  • Expensive - $3k list
  • Unable to draw arbitrary lines for unsupported relationships
  • No customisation
  • Process flows - unable to do functional decomoposition (?)



0 comments: