Suppose I wanted to design an app around a database, but wasn’t sure yet which database I wanted to use. I just want to layout my fields and relations, perhaps in a visual or graphical way (see FileMaker’s relations editor), then create the actual database later using my design as a template. In other words, I want a database prototyper. Is there a tool available for that?
You’re looking for an ERD tool that can eventually spit out the SQL to create the database design ?
entity relationship diagram
Usually what a “data model” is called
Just found the description here. Yes, that’s what I’m looking for.
supports a fair number of db’s and it’s not outrageously price & gets decent reviews
Excellent! Based on that web page, it seems exactly like what I was envisioning. I’ll download to try it out now.
supports a fair number of db’s and it’s not outrageously price & gets decent reviews[/quote]
We’ve been using this tool for a current project, and it is pretty good. It does have a few bugs, but overall, has been quite stable, and the developer is responsive. The most current version can address SQLite directly rather than through JDBC as used to be the case.
I second Norman’s recommendation.
+1. Been using this for years. Developer is very responsive.