search

12357David19 / mdb-sqlite

Automatically exported from code.google.com/p/mdb-sqlite
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

Feature request: Convert table relations #8

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
The current version does not support any kind of foreign key/relation 
conversion.  This feature is all but ignored by sqlite as it does not 
enforce referential integrity.  However, there are some applications for 
which it would be useful to have the table relationships in the sqlite 
database.  For example, SQLite Maestro 8.5 has a visual database designer 
tool which interprets the foreign keys of every table in order to properly 
draw the relationships of the database in the diagram.
The current version of mdb-sqlite loses this information in the conversion 
process.

I have attached a proposed solution.  This solution was tested with 
Jackcess version 1.1.18 and sqlitejdbc-v053.

Dmitriy Ofman

Original issue reported on code.google.com by dimaof...@gmail.com on 14 Nov 2008 at 5:39

Attachments:

GoogleCodeExporter commented 8 years ago

Original comment by landon.j.fuller@gmail.com on 14 Nov 2008 at 6:33