Using SchemaSpy to Visualize a SQLite Database (Windows)

Question

I am trying to dump sqlite using SchemaSpy. I started SchemaSpy and was able to correctly reset the MySQL database.

Now I have a .sqlite file (from an iOS application) and a sqlite driver from Christian Werner ( http://www.ch-werner.de/javasqlite/overview-summary.html ). The example from here explains how to work with this, but to be honest, I don’t understand what to do.

Is there anyone who knows how I can use SchemaSpy on Windows? I do not need to use the GUI tool.

Answer 1

, , , . DLL SQLite.

, system32 Windows (, C:\Windows\System32 )

, JDBC:

java -jar… -dp "D:\SchemaSpy\driver\j2sdk1.4.2_03\jre\lib\ext\sqlite.jar" …

Answer 2

, sqlite. , SchemaSpy DB sqlite, . -

java -jar schemaSpy.jar -t sqlite -db < > -o <output>

Answer 3

- SchemaSpy. MySQL, , -t sqlite " " .sqlite.

SQLite JNI , , sqlite_jni.dll PATH. PATH Windows:

PATH =% PATH%; directoryContainingTheJniDll

Answer 4

, .

JDBC. UNIX, - Windows. sqlite.jar .dll, . classpath, .

, CLI sqlite3 .schema , , . Ubuntu VM;)

Answer 5

, , SchemaSpy JDBC Xerial SQLite , .properties, http://schemaspy.sourceforge.net/dbtypes.html

, , sqlite.properties, sqlite-xerial.properties ; :

driver=org.sqlite.JDBC

description=SQLite-Xerial

driverPath=sqlite-jdbc-3.7.2.jar

Xerial DLL JNI, FK - , SQLite 3, .

, , SchemaSpy , []. :)