Geek Answers Handbook

How to create an EER model from sqlite db

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

+8
java sqlite entity-relationship reverse-engineering eer-model
source share
1 answer
  • Open SQLite File Using SQLite Database Browser
  • Export to SQL
  • Import (using the plugin) in Workbench

More details:

If you have a sqlite file available, open it with the free SQLite Database Browser . This gives you several ways to check the database:

  • view table structure
  • view table contents
  • issue content requests
  • and much more...

In addition, you can choose to export the SQL file. Go to "File> Export> Database to SQL file" in SQLite Database Browser.

After creating the SQL output file, use the SQLite export plugin for MySQL Workbench - especially if you are already familiar with the MySQL Workbench tool.

+10
source share

More articles:


All Articles