ERD Diagrams -- Free options & Questions
Posted on 2006-05-18
I just took on a client with two databases. Both databases are hosted on SQL Server 2005 and both are currently accessed using MS Access 2003. The databases are about 10 years old and have passed through nearly as many developers so there's a lot of old and unused information and fields. I need to create an ERD for each database and clean out/delete the old fields and tables.
Suggestions I need:
1) Are there any FREE programs that will create ERD's for me? If not, are there any that don't cost hundreds of dollars? The databases are extremely large so don't need an extremely powerful tool.
2) The db's use Access forms and reports for data entry. This is probably a newbie question...but how are forms, reports and their associated queries represented in an ERD? For the programs that create automatic ERD's WITH RELATIONSHIPS (such as Visio), will they also show what queries, forms and reports are pulling information from the tables? My issue is that I think probably 50%-80% of the forms and reports are old and I want to delete them but I'd like to have an automated way to see all the relationships between forms/queries/reports are so that I can weed out the old stuff.
3) How would you, the expert, go about the task of cleaning out a medium sized database? What tools would you use?
Any help would be appreciated.