Small. Fast. Reliable.
Choose any three.
Web Win. Lin. Misc. Name Description Licence / Price Trial Version

x

SQLite Data Wizard 11.1
(updated 2011/01/17)
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).

SQLite Maestro is developed by SQL Maestro Group that also offers complete database management tools for MySQL, Microsoft SQL Server, Oracle, DB2, SQL Anywhere, PostgreSQL, Firebird and MaxDB.

From $79 30 days

x x OS X mysql2sqlite 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. free -

x x Mac OS X SQLite Migrator With SQLite Migrator, you can migrate any database that you can connect to using ODBC to SQLite. $49.95 demo

x x
MDB-SQLite: Access -> SQLite Provides automated conversion of MS Access 2000 databases to SQLite on any platform, utilizing Jackcess and SQLite Java libraries. No native driver required. No Windows required, either. free -

x

DBConvert for SQLite&MySQL, DBSync for SQLite&MySQL DBConvert for SQLite & MySQL and DBSync for SQLite & MySQL are reliable bi-directional database migration software which allow you to convert and synchronize databases from SQLite to MySQL or from MySQL to SQLite. DBConvert Product Line contains tools for MS SQL Server, MySQL, PostgreSQL, Microsoft Access, Microsoft Excel, FoxPro database conversion and synchronization as well. Welcome to evaluate! $79 -

x

ESF Database Migration Toolkit Data migration across SQLite and others database/file systems, e.g. SQLite, SQL Server, Oracle, MySQL, PostgreSQL, MS-Access, MS-Excel, Foxpro and so on. From $219 30 days

x

SQL Server To SQLite DB Converter Server To SQLite DB Converter is a free (public domain) utility written in C# that allows you to automatically convert from an existing SQL Server DB to a (mostly) equivalent SQLite database. free -

x

Fox2Lite A DOS foxpro program for converting fox .dbf files to sqlite tables. {link: mailto:rafeek.mk@gmail.com Tested} for sqlite v 3.6.3 free -

x

dataPro Conversion Tool for SQLite, MySQL, PostgreSQL, Oracle, SQL Server and Microsoft Access. Transfer database objects between 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. $99.95 limited free version

x

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

x x
SQLFairy or SQL::Translator 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. GNU GPL -

x

Firebird <-> SQLite Windows executable with sources. free -

x

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. LGPL -

x

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 <dbname> -t <tablename> > /tmp/<dumpfile> ...and so on...

Trim off crap from header and footer from each file, eg:

$ nano -w /tmp/<dumpfile>

If required, create SQLite file and tables corresponding to tables in the original PostgreSQL database:

$ sqlite3 <dbname> sqlite> CREATE TABLE ...etc...

Finally, import the dump files into SQLite, remembering to change the default import separator to a <tab>:

$ sqlite3 <dbname> sqlite> .separator "\t" sqlite> .import <dumpfile> <tablename>
- -

x

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). - -

x x
Xplain2sql

Xplain2sql converts Xplain statements to SQL statements. Currently it can convert from Xplain to Microsoft SQL Server, Borland InterBase, Firebird, DB/2, Oracle, PostgreSQL, SQLite 3, MySQL, ANSI-92 SQL, Microsoft Access and FoxPro. Usage:

xplain2sql -sqlite3 input.ddl > output.sql
GNU GPL -

x x
t2sql

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:

  • fx2lite.prg 5579 bytes added by anonymous on 2006-Sep-21 09:03:53 UTC.
    • A DOS foxpro program to transfer .dbf into an sqlite table is here

  • 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.
  • t2sql 5432 bytes added by anonymous on 2008-Aug-16 17:59:56 UTC.
    unix script to convert text file to sqlite db (see t2sql above)
  • fox2lite.prg 6037 bytes added by anonymous on 2008-Oct-03 19:51:21 UTC.
    FOX2LITE A DOS foxpro prg file to convert foxpro .dbf files into sqlite tables. Older fx2lite modified to reflect current (3.6.3) sqlite version. (rafeek.mk@gmail.com)
  • MDB2SQLite_v2.vbs 23528 bytes added by anonymous on 2009-Jan-22 06:21:39 UTC.
    • Added function for exportIndexes - create Indexes (except Primary Key)
    • Added NOT NULL and DEFAULT values in CREATE TABLE (Now() = CURRENT_TIMESTAMP)
    • Fixed CREATE TABLE without Primary Key
    • Added creating TRIGGERs instead of FOREIGN KEY constraits.
    • Added Const dbExportData for genereting scripts without INSERT instructions
    • Added type INTEGER PRIMARY KEY for field type COUNTER