UsingSQLiteProviderWithDTS

Introduction

Many times, you may want to import data from SQLite into SQL Server since SQLite has limited functionalities. In this case, SQLite OLE DB Provider can be used so that it will save you a lot of valuable time. The following sections will show you how to use SQLite OLE DB Provider with DTS to import SQLite data into SQL Server databases and discuss some of the limitations as well.

Using SQLite Provider With DTS

Like Using MySQL OLE DB Provider with DTS, using SQLite OLE DB Provider with DTS is very similiar. They are also 10 steps of which most are the same. Please refer to Using MySQL OLE DB Provider with DTS. Only sep 1 and step 2 are slightly different.

At step 1, you shall select SQLite Provider instead of MySQL Provider

At step 2, you only need to fill in the data source with the SQLite database file name.

Data Type Mapping Between SQLite and SQL Server

When using SQLite OLEDB Provider with DTS to transfer SQLite data into SQL Server, make sure all columns are mapped with the right data types.

SQLite Data Types SQL Server Data Types
BIGINT BIGINT
INTEGER INT
SMALLINT SMALLINT
TINYINT TINYINT
BIT BIT
DATETIME DATETIME
VARCHAR NVARCHAR
CHAR NCHAR
TEXT NTEXT
BLOB IMAGE
FLOAT FLOAT
REAL REAL

Limitations

The data type mapping above gives us a guideline on how do we map data columns between SQLite and SQL Server. The current limitations are as follows: