I have been working with Data Modeller for a new project even though I have owned the product for a few years.
I would make a few suggestions
- A way of easily editing/cleaning up existing import from database connections used while reverse engineering a database.
- Import/Export from Spread sheet - when reverse engineering an existing database issues arise when dealing with legacy naming conventions, captions that differ from physical names etc. The ability to dump to a standard xcell workbook, make a series of changes and then re-import it back into a project would make the tool far more useful.
- Project explorer --> few projects depend upon a flat design approach. You may group your SQL objects under schema/name-spaces/users/operational tasks and even further sub-divide those actions by the database/instance those objects are on or even the servers/cluster that houses the work. All of this could be easily shown with a user defined tree structure where you can move items up or down the tree or define new tree nodes to organize your work as it is needed. This would help with projects with a great number of diagrams as well as re-factoring data structures (having your existing data structure on one branch of the tree while another branch holds the target structure). It would even aid in separating physical and logical designs.
- New database graphical elements such as views, triggers, stored procedures etc., so that you can graphically show the various metadata dependencies and process flow within the diagrams.
- Pseudo result set/diagram data - many design elements and business rules have stored procedures and triggers check for values within the database - it would be good to be able to show these values in a grid on the diagram and perhaps have the grids generate insert statements within the output script. It would also help in documenting the design for inclusion in a larger documentation set.
- New diagram graphical elements such as page borders, diagram legend, pictures etc to help make the programs output match with a larger set of documentation.
- Elements to work with security permissions such as creation/documentation of Roles and Grants.
- Make a 64bit version available as there are issues with memory with large complex projects with the current version.
Best regards
Dalton