But I want to eventually make it.įirst of all, I had already pre-installed on my computer (a Mac OS) the latest version of XAMPP (7.3.33 at the time of writing this article), so I had no desire to downgrade to a previous version with MySQL DB installed, as suggested in some posts on StackOverflow. Getting MariaDB (database provided by new versions of XAMPP) to talk with MySQL Workbench was not a very simple operation. The tool in question is called Reverse Engineering.Īnd here the problems arose.
I remembered from distant reminiscences that MySQL Workbench provides a very powerful tool for the automatic conversion of SQL schemas into ER diagrams. However, since my boss had asked me to produce this blessed ER diagram, and not have the desire to manually move the tables one by one in the graph, I thought about using MySQL Workbench. Furthermore, the PhpMyAdmin Designer is a very basic tool, which does not allow you to automatically align the tables to make them more readable. My database had over 20 tables and the Designer showed them all stuck on top of each other. I usually use XAMPP to work in SQL so I told myself to try using the Designer tool provided by PhpMyAdmin. I happened to have to extract the Entity-Relationship diagram starting from the SQL schema.
0 kommentar(er)
