Description

Connects to a SQL Server database, displays a list of all non system databases found. Creates a SQLite database file by reading the tables, indexes and data in the chosen SQL Server database.
SQLite encryption can optionally be selected.

Instructions

• Download the zip archive (below)
• Unzip to a location of your choosing
• Run the file "SQLServerToSQLite.exe"

Usage Notes

If tables exist in the in the destination (SQLite file) they are always dropped before being re-created.
Always make a backup if you plan to use this tool on existing SQLite files.

Pre-Requisites

.NET Framework 2.0 is required
Tested against SQL Server 2000 and 2005, on XP, Vista & Windows Server 2003.

Known Issues

The tool tries to create indexes in SQLite using the name of the existing indexes in SQL Server. Some names are not supported in SQLite, in this case index creation will fail.
If any failures occur a log file fill be created called "SQLServerToSQLite.log", this log file will be created in the same location that you chose for the SQLite Database file.

Usage, Licence & Modifications

The tool is free to use.
Legal bit: This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
Dancing House Consulting will accept no liability for any loss or damage through use or misuse of this software.

Modifications
If you are a developer and wish to work with me to improve this tool, get in touch and I can make the source code available.
If you are a company and want to commission me to make modifications to this tool, please contact me.

Download

Download SQLServer To SQLite Converter Version 1.0.0 (29 Dec 2009)