Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

2 Answers 2

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.

You could also migrate the database schema into SQL Server and leverage the database diagrams found there. You should be able to use SQL Server Express for this.

share|improve this answer

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).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.