I want to create an ERD for our existing Singlestore DB. Can anyone recommend a tool that will help me do this? I tried Sql Workbench --> Database --> Reverse Engineer but it bombs when I try to select tables.
I understand there are no FK so I will have to highlight the joins myself but it would be a great help if I could at least extract the tables into a diagram.
Hi @claire.moore – welcome to the SingleStore forums. I don’t have a great answer for you. A roundabout way to do it would be to export your schema as CREATE TABLE statements using
sdb-admin dump and work with that.
You could edit the file so it runs the CREATE TABLE statements successfully on MySQL, then import them from MySQL with Sql Workbench, then add the edges.
What error did you get with Sql Workbench, and what’s the full name and version of the product you were using? MySQL workbench might work better, perhaps. Our catalogs do have basic backward compatibility with MySQL.
Thank you for the reply !
I am using Mysql Workbench 6.3 Community edition.
I go to Database --> Reverse Engineer
It goes through steps of connecting and retrieving fine bringing back my tables and views.
When I deselect everything, select a couple of tables at random then use the right arrow to bring them across I get Workbench has encountered a problem, external component exception and please report bug.
I can log a bug but I am not sure if Mysql Workbench is supposed to offer this feature for Singlestore.