This information is obsolete. You are looking at the
CVSTrac source management system display
for SQLite that was replaced by
Fossil on 2009-08-11. The
information shown here has not been updated since that cut-over.
These pages are retained for historical
reference only.

SQLite Data Wizard is a powerful Windows GUI utility for managing your SQLite data. It provides you with a number of easy-to-use tools for performing the required data manipulation easily and quickly.

Key Features:

Data Pump: transfer any schema and data to SQLite

Data export to as many as 18 file formats

Data import from Excel, CSV, text files and more

ASP.NET Generator: create full set of ASP.NET scripts

Flexible Task Scheduler

The Agent application to execute tasks in background mode

Powerful command-line interface

The latest version (11.1) was released at January 17, 2011. It comes with data import from any database accessible via ODBC driver or OLE DB provider, the insert-or-update data import mode, advanced Data Pump abilities, and some other new features (read full press-release).

Shell script that converts a mysqldump file into Sqlite3 compatible SQL file. It uses awk for speed and portability. Runs on Windows with the Cygwin tool for Windows.

free

x

x

iPhone

Use our StepSqlite tool to migrate Oracle PL/SQL package code directly to SQLite loadable-extension or to a regular C++ library ready for use in your apps. Includes automatic optimization of code to run fast on SQLite.

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.
This article shows a script to do an automated conversion from MDB to SQLite using mdbtools.

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.

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:

Simple shell (bourne) script to convert a text file to a sqlite database. Will create or append to tables. (script attached below) Defaults to tab-separated files (.tsv), but can work with other delimiters too.

-

-

Web

Win.

Lin.

Misc.

Name

Description

Licence / Price

Trial Version

Attachments:

MDBtoSQLite.vbs
16259 bytes added by anonymous on 2008-Jan-18 11:07:20 UTC.
Takes in an MDB and produces a text file that can be piped into the sqlite command line tool to create a database.
2008-01-16 <lokkju@lokkju.com>
Fixed INTEGER field types to handle null data, now will insert 0, used to break it by inserting nothing. Also modified to accept database path from the command line as an argument.