I am working on a new application that uses a jet (MS Access) database. I have built the database using FluentNHibernate's AutoMapping feature from my C# objects.
I need to present this database for an on-line WebEx design review on Tuesday and am looking for a tool to create ERD's for my database that I can group onto slides.
The diagramming in MS Access is poor-to-unusable.
I have: VS2008 Pro, MS Access 2007, Visio 2007, Visio for Enterprise Architects, etc... My C# Code Schema exported with NHibernate Hbm2Ddl hbm.xml mapping files created by FluentNHibernate .accdb file containing the database
I need: quick, free and easy way to create clear diagrams.
Since I have everything for Fluent NH and NHibernate, I could use their drivers/dialects to create a schema for any supported database to use in generating the diagrams.
Any suggestions to help?
If your MS Access DB has all the attributes of a real DB like constraints etc... then Visio should import the DB. If that it not working for you... import the DB into SQL Server. SQL Server has some rudimentary tools for drawing basic ERDs... and Visio with import from SLQ Server.
The "correctness" and "complexity" of the ERD is going to be up to you in the end and how you extend the captured data.
Good luck