I am evaluating TOAD Data Modeler. It is a good product, but I cannot see it handling the following scenario. We use an ORACLE 9i database with multiple schemas, and foreign keys can span from one schema to another. I would assume you could reverse-engineer each schema into a separate workspace, but how can you set up a foreign key relationship between 2 tables in different workspaces. You could clone tables, but for QA reasons, you would only want each distinct table defined once.
Also, this product seems targeted to individual programmers. Can it be successfully implemented to be used by a team?