I have a database diagram that I would like to extract from SQL and manipulate it to create a user-friendly and easier-on-the-eye ERD. The database contains over 200 tables and I would like to map the tables out to show other how it works to others.

I don't want to reverse engineer as Visio reformats the ERD and no longer looks like the model I have in database designs.

I'm aware that you can right-click and copy-to-clipboard however this captures the model as an image which means I can't manipulate it.

Is there an alternative piece of software out there that I'm not aware of?

  • I don't think that there's any tool out there that can read from the SQL Server diagrams themselves. All ERD tools will reverse engineer the schema and will auto arrange the tables. You need to either use the diagrams you have now or prepare new ones in another ERD tool.. – Marian Oct 12 '12 at 17:42

I'd check out Embarcadero tools Try Data Architect.

| improve this answer | |

You can use the "free" MySQL workbench if you are using MySQL https://www.mysql.com/products/workbench/ to reverse engineer the model from an SQL file then re-organize the model into multiple pages.

| improve this answer | |
  • unfortunately I'm not using mysql...thanks for your input though. – Russell Jackson Oct 15 '12 at 8:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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