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