*: {link: http://www.sqlmaestro.com/products/sqlite/datawizard/ SQLite Data Wizard} _:: SQLite Data Wizard provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. SQLite Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to your SQLite database, export data from SQLite tables and queries to most popular formats, and import data into the tables. _:: SQLite Data Wizard developed by {link: http://www.sqlmaestro.com/ SQL Maestro Group}, which also offers such tools for MySQL, Oracle, MS SQL Server, PostgreSQL, Firebird and MaxDB. *: A DOS foxpro program to transfer .dbf into an sqlite table is here _: {link: http://www.sqlite.org/cvstrac/attach_get/293/fx2lite.prg} *: {link: http://www.vive.net/products/datapro.htm dataPro} _: Conversion Tool for SQLite, MySQL, Oracle, SQL Server and Microsoft Access. Transfer database objects beetwen different databases and servers, convert tables schema and migrate data from one database type to another. Comes with integrated SQL editor to run SQL queries and graphical user interface. _: {link: http://download.vive.net/trial/dataPro_trial.exe Download dataPro} _: Here is the Microsoft sample Northwind database converted to SQLite  {link: http://download.vive.net/Northwind.zip Northwind} *: {link: http://mdbtools.sourceforge.net/ MDB Tools} _: The MDB Tools project is a effort to document the MDB file format used in Microsoft's Access database package, and to provide a set of tools and applications to make that data available on other platforms. _:Specifically, MDB Tools includes programs to export schema and data to other databases such as MySQL, Oracle, Sybase, PostgreSQL, and others. _:Also, included is a SQL engine for performing simple SQL queries. The 0.5 release includes an updated GUI interface (screenshot is available here). A sparse but functional ODBC driver is included as well. _:MDB Tools currently has read-only support for Access 97 (Jet 3) and Access 2000/2002 (Jet 4) formats. Access 2000 support is a recent addition and may not be as complete as Jet 3 support. _:Write support is currently being worked on and the first cut is expected to be included in the 0.6 release. _:*Note:* I don't think it supports SQLite right now, but this project can be continued and used for that purpose. *: {link: http://jackcess.sourceforge.net/ Java Library for MS Access} _: Jackcess is a pure Java library for reading from and writing to MS Access databases. It is not an application. There is no GUI. It's a library, intended for other developers to use to build Java applications. Jackcess is licensed under the GNU Lesser General Public License. _: This link was included in contrast to the MDB Tools link above. Similarly, it has no SQLite understanding at this time. *: Simple VB MDB to SQLite _: I coded up a small limited visual basic tool that takes in an MDB and produces a text file that can be piped into the sqlite command line tool to create a database. It's simple and very dirty code, but it does work for simple databases. It's attached to this document and you can do whatever you want with it. _: i did a few improvements to vb mdbtosqlite to convert northwind, orders, biblio, and gallery ms-access sample mdbs to sql code loadable in sqlite. everything was read fine, with the exception of binary picture fields, which are also been reported in the output file, as comments closely following each create table statement. the ofending fields are still being created with "BINARY" type and inserted as NULL. code is posted as mdbtosqlite2.zip, so that the original author might examine it and hopefully merge the two versions. _: I have modified this program into a vbs so you don't have to have Visual Basic. _: Changed function getSQLiteFieldType according to dao360 docs to handle datatypes properly. _: the link: http://burke.ath.cx/~ernesto/MDBtoSQLite.vbs _: (2008-01-16): Fixed some INTEGER field bugs, made it accept an argument for the MDB file to process. Attached as a file below. *: {link: http://sqlfairy.sourceforge.net/ SQLFairy or SQL::Translator} _: From their website: _: SQL::Translator is a group of Perl modules that manipulate structure data definitions (mostly database schemas) in interesting ways, such as converting among different dialects of CREATE syntax (e.g., MySQL-to-Oracle), visualizations of schemas (pseudo-ER diagrams GraphViz or GD), automatic code generation (using Class::DBI), converting non-RDBMS files to SQL schemas (xSV text files, Excel spreadsheets), serializing parsed schemas (via Storable, YAML and XML), creating documentation (HTML and POD), and more. New to version 0.03 is the ability to talk directly to a database through DBI to query for the structures of several databases. _: Excellent tool which helped me migrate from MySQL to SQLite. *: {link: http://www.rosa.nl/Bold2 Firebird <-> SQLite} _: Windows executable with sources *: {link: http://www.kexi-project.org/ Kexi} _: Kexi (Open Source MS Access competitor) is able to import/export database schemas between SQLite format (which is Kexi's native format) and server engines (MySQL, PostgreSQL) and MS Access (using MDB Tools). User-friendly wizards are prepared. Importing tables with CSV format is also available with a nice GUI. *: PostgreSQL to SQLite3 _: After a little experimenting, I found a way to import data from PostgreSQL into SQLite, version 3, without having non-ASCII characters ruin things (something that getting pg_dump to export SQL statements did...). It could be enormously improved with a little scripting love, but as I only had one database with a couple of big tables to deal the below was fine, however... post improvements! Export the data from your database as tab delimited text. Create one text file for every table in your database: $ pg_dump -a -t > /tmp/ ...and so on... Trim off crap from header and footer from each file, eg: $ nano -w /tmp/ If required, create SQLite file and tables corresponding to tables in the original PostgreSQL database: $ sqlite3 sqlite> CREATE TABLE ...etc... Finally, import the dump files into SQLite, remembering to change the default import separator to a : $ sqlite3 sqlite> .separator "\t" sqlite> .import *: MySQL to SQLite3 (shell script) _: A quick way to convert a MySQL DB to SQLite3 is the following shell script (it does not claim to be complete): #!/bin/sh if [ "x$1" == "x" ]; then echo "Usage: $0 " exit fi if [ -e "$1.db" ]; then echo "$1.db already exists. I will overwrite it in 15 seconds if you do not press CTRL-C." COUNT=15 while [ $COUNT -gt 0 ]; do echo "$COUNT" sleep 1 COUNT=$((COUNT - 1)) done rm $1.db fi /opt/lampp/bin/mysqldump -u root -p --compact --compatible=ansi --default-character-set=binary $1 | grep -v ' KEY "' | grep -v ' UNIQUE KEY "' | grep -v ' PRIMARY KEY ' | sed 's/ unsigned / /g' | sed 's/ auto_increment/ primary key autoincrement/gi' | sed 's/ smallint([0-9]*) / integer /gi' | sed 's/ tinyint([0-9]*) / integer /gi' | sed 's/ int([0-9]*) / integer /gi' | sed 's/ character set [^ ]* / /gi' | sed 's/ enum([^)]*) / varchar(255) /gi' | sed 's/ on update [^,]*//gi' | perl -e 'local $/;$_=<>;s/,\n\)/\n\)/gs;print "begin;\n";print;print "commit;\n"' | perl -pe ' if (/^(INSERT.+?)\(/) { $a=$1; s/\\'\''/'\'\''/g; s/\\n/\n/g; s/\),\(/\);\n$a\(/g; } ' > $1.sql cat $1.sql | sqlite3 $1.db > $1.err ERRORS=`cat $1.err | wc -l` if [ "$ERRORS" == "0" ]; then echo "Conversion completed without error. Output file: $1.db" rm $1.sql rm $1.err else echo "There were errors during conversion. Please review $1.err and $1.sql for details." fi *: {link: http://www.pobox.com/~berend/xplain2sql/index.html#downloadbeta xplain2sql, Xplain to SQL converter} _: xplain2sql converts from Xplain to many SQL dialects. The beta 2.3 release adds very complete support for SQLite. _: usage: xplain2sql -sqlite3 input.ddl > output.sql *: {link: http://www.reddawn.net/~jsprenkl/Sqlite/ SqliteImporter} _: SqliteImporter: Command line fixed and delimited text import.