How to import a SQLite db file into DbVisualizer

Question

How can a SQLite *.db file be imported into DbVisualizer? Since the SQLite database file extension is *.db how can we load this into DbVisualizer to view the tables and generate the ER diagram?

score 18 · Accepted Answer · edited Jul 17 '17 at 13:13

18

In DbVisualizer open Tools->Connection Wizard. In the Select Database Driver pane pick SQLite from the list and click Next.

In the last details pane load the file (.db or .sqlite) in the Database file name field. Click Finish and you should be connected.

edited Jul 17 '17 at 13:13

Sebastian

2,896
23
36

answered Jan 12 '17 at 16:40

roger

641
4
7

2

On Windows, make sure not to have quotes around the file path. – Noumenon Sep 23 '17 at 19:39

score 1 · Answer 2 · answered Mar 31 '23 at 01:22

1

On version 23.1 I couldn't find the option described in the initial answer. It is actually a little bit easier. Database > Create Database Connection and search SQLite, then you will see the field Database file name.

answered Mar 31 '23 at 01:22

Sebastián Ulloa

107
9

How to import a SQLite db file into DbVisualizer

2 Answers2

Linked