Visual Schema

[sturgis]

Slightly off topic maybe but..
I'm using LC to interface with a database from another program. The company that writes it has EOL'd the application so I am working on a way to keep the data accessible when the app expires and becomes non-functional.

So far it hasn't been too bad, got the db cnverted to sqlite which seems to be running SO much faster than the original application. I can pull data out no problem. The main issue is that the database is pretty complexes.

While this is not LC specific, does anyone know of a tool that will read an sqlite schema in a visual way so I can "connect the dots" and figure out how everything relates to each other? The current design is kinda a mess with redundant data, tons of empty tables.. I suspect that as the applications life has been progressing changes were being made to the schema with no thought to efficiency or cleanup of the structure as changes were being made. (it happens)

The LC side of things has been a breeze the only holdup is deciphering the schema. A visual tool would help immeasurably. All suggestions welcomed.

[Bernard]

You don't say what platform you are using. If you are on Windows or Linux you could try this: http://sourceforge.net/projects/dbdesigner-fork/

The guy who made the original (pre that fork) went off to be employed turn his version into the main db visualisation/sql tool for MySQL.

[sturgis]

Haven't dug into it very far but that looks like it will do the trick. Thanks very much. Not on windows or linux but I can run it in a VB so i'm good to go. Thanks!