I have database scheme for Microsoft Access. I'm interested how I can convert the scheme into an ER diagram? Is there any tool that can do this based on scheme relations?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Visio Professional(prior to 2013) has an option to reverse engineer a database schema. I have used this in the past for Access as well as other databases. However, it does mean you have to purchase the professional version.
Export a database schema from MS Access seems impossible. The only way is to migrate your database to MySQL Worbench which has a real modeling and migration tool. With the option of reverse engineering, you'll be able to get a ER Diagram of your database. In this DBMS, you can also specify the type of normalization (e.g UML) that you want.
The other option is to create your own ER Diagram without an importation via some free software like UMLnet (but can appear very long depending of database size).