|I'm using Oracle SQL Developer Data Modeler[^]
Supports Oracle (duh), MSSQL and DB2.
ole.Grossklaus@gmx.de wrote:- reverse engineer to have a starting Point (Oracle 11 and MSSQL2008) to have all tables in this tool (on a hidden layer if possible
It's tab based, you can create a new view with a subset of existing tables.
ole.Grossklaus@gmx.de wrote:- Select some tables and copy them (link) to a new layer to switch visibility depending on the development task that i want to give to a developer
ole.Grossklaus@gmx.de wrote:- Display compact (square with table Name, and PKs only). Hide all other columns
Auto arrange sucks big donkey balls. But it does in all tools in my opinion. So it's up to you to do the work I'm afraid.
ole.Grossklaus@gmx.de wrote:- a good way to arrange everything on Screen to avoid crossing Relations and to nicely arrange every table and relation
It's tab based, and you can have one or more windows and move the tabs between them.
ole.Grossklaus@gmx.de wrote:- toggle visibility of a layer
A table can appear in many windows/views, not sure if this is what you mean.
ole.Grossklaus@gmx.de wrote:- a certain table appears on more than one layer depending on the development tasks
ole.Grossklaus@gmx.de wrote:- something that makes it all "nice" to present to the Boss.
Barker notation - check
ole.Grossklaus@gmx.de wrote:- crow feet Notation
Be excellent to each other. And... PARTY ON, DUDES!