How to create EER model from a sqlite db

java sqlite entity-relationship reverse-engineering eer-model
JackTurky picture JackTurky · Jun 11, 2012 · Viewed 11k times · Source

i'm using sqlitejdbc libraries to create a db using java. Now i need to generate eer model from existing sqlite db stored in a file. In past i used MySqlWorkbench to generate eer from a mysql db, but i don't know how to do that on sqlite db.. can someone help me? thanks!!

Answer

MiStr picture MiStr · Jun 21, 2012
  1. Open SQLite file using SQLite Database Browser
  2. Export to SQL
  3. Import (using plugin) into Workbench

Details:

If you have the sqlite file available, open it using the free SQLite Database Browser. This gives you a few ways in which to inspect the database:

  • view table structure
  • view table content
  • issue queries against content
  • and more...

Beyond this, you can opt for the SQL file export. Go to "File > Export > Database to SQL file" option inside the SQLite Database Browser.

Once you create the SQL output file, use the SQLite export plugin for MySQL Workbench - especially if you're already familiar with MySQL's Workbench tool.

Related questions

SQLite in Android How to update a specific row

I've been trying to update a specific row for a while now, and it seems that there are two ways to do this. From what I've read and tried, you can just use the: execSQL(String sql) method or the: …

Read More
Java and SQLite

I'm attracted to the neatness that a single file database provides. What driver/connector library is out there to connect and use SQLite with Java. I've discovered a wrapper library, http://www.ch-werner.de/javasqlite, but are there other more …

Read More
Most simple code to populate JTable from ResultSet

I googled the whole day and no luck. I call getnPrintAllData() method after pressing OK button. So the code is: public class DatabaseSQLiteConnection { Connection conn = null; PreparedStatement statement = null; ResultSet res = null; public DatabaseSQLiteConnection(){ try{ Class.forName("org.sqlite.JDBC"); …

Read More